directory file saving

[SAPaul]

i have a workflow that is made just to copy files from one location to another, using a macro it it works for is not working with xls files , is there a fix for this?

Attached the file saving workflow, the macro to save files, and the sheet reader/finder macros. The first macro just parses out hotel name and date to be used in formula (tool 45)

First picture is workflow when running the same macro for csv files. Second when running for xls files. i have tried the sheet finder/sheet reader macros (sheet finder doesnt seem to read all files without sheet reader being there?). can someone explain where am going wrong

[JosephSerpis · Accepted solution]

Hi @SAPaul if you need to copy files then you don't actually need a macro you can use the blob tools to copy files to a new folder. I've attached an example.

[SAPaul]

thank you!