How to define Path while using Assign Activity?

Hello,

Can anyone please help me with below error.

Assign Activity -
Left box (Excelflile) - Right Box (Directory.GetFiles( CurrDir + “C:\Users\Desktop\Merge\Input File”,"*.xlsx")

Error Message - Assign: The given path’s format is not supported.

I am trying to merge all excel files in the input folder and save the merged file in the output folder.

Thanks HD

1 Like

Directory.GetFiles(“C:\Users\Desktop\Merge\Input File”,"*.xlsx")

Use this syntax

Thanks
@HD001

2 Likes

Thanks it worked but now i am receiving below error, can you help with this as well ?

Append Range: The given path’s format is not supported.
image

HI @HD001

I think you need a slash after the folder name “Input File”

Like this
Directory.GetFiles(“C:\Users\Desktop\Merge\Input File\”,"*.xlsx")

5 Likes

Input file error is resolved.

I am now receiving another error with Append Range activity please refer to the snap shot above.

Thanks.

1 Like

Whats the error that you are getting? Can I see the error details?

1 Like

May i know the error you were getting
@HD001

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.