Can't open file:, The filename, directory name, or volume label syntax is incorrect.

Question

Hi team,

I am getting below error.

Error: Output Data (29): Unable to Open archive for zipping: Z:\CRS Bmth Migration\Depo Services Change\2023\FM UTs Remediation\DS Daily NAV Check\*BE DK FI NL NO SE*.xlsx Can't open file: Z:\CRS Bmth Migration\Depo Services Change\2023\FM UTs Remediation\DS Daily NAV Check\*BE DK FI NL NO SE*.xlsx: The filename, directory name, or volume label syntax is incorrect. (123)

Configuration is below. There is already a file named "BE DK FI NL NO SE DAILY NAV MOVEMENT.xls" and contains sheet "CurrentDaily"

Can you please help if I am missing something?

binu_acs · Accepted Answer

@Praneeth1996 Can you try without the * and give the full name in the path .\BE DK FI NL NO SE DAILY NAV MOVEMENT.xlsx|||'CurrentDaily$A7:A2000', also make sure that the file exists in the same folder where you saved your workflow

flying008 · Accepted Answer

Hi, @Praneeth1996

The windows file name can't contain '*' character, so your  *BE DK FI NL NO SE*.xlsx is incorrect.  you need remove it or rename.