Can't use relative path in 'Append Range Workbook' activity

Hi All,
I use a relative path inside the ‘Append Range Workbook’ activity and when I try to run the workflow there is an error.

Then I tried to run the workflow with an absolute path inside the ‘Append Range Workbook’ activity and it ran successfully.

This is how I created the Excel file in another workflow.

I need to use the date in the file name because the Excel file needs to be created and filled in daily. Is there any advice on how to solve the problem?
Thanks

Hi

It seems double quote matter. For now, can you try to replace (re-type) all the double quote wilth " (0x22 character)? (Please copy and pate this character " if necessary)

FYI

Regards,

2 Likes

I already replaced the double quote in the workflow by copy-pasting the character you give, but when I ran the file the error is still exist

image

Thanks

Do the same, replacing double quotes, for Sheet Name

Also, I recommend using String.Format instead of concatenating to define the file name

Hi @Nafissa_Al_Abida

The error you are getting refer that your doubles are not correct given in Append Range Workbook.

Try the below in Append Range Workbook

"SFRequestData"+Today.ToString("MMddyyyy")+".xlsx"

Regards

I try to use string.Format and it worked, Thanks

1 Like

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