This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi I have just recently updated to 19.3 But now I cannot get any of my macros working that imports multiple xlsx files from a folder.Anyone got any ideas? Errors:Error: Multiple Sheets Multiple Excel Files (15): Record #14: Tool #2: Field: "Sheet Names" is 0 length.Or:Error: Claje_LoadMultipleExcelFiles (1): Record #20: Tool #1: No sheet specified, you must specify a sheet- Any thoughts?
Go to Solution.
Go to Solution.
Could you check the input tool section (3)?
If this solves your issue please mark the answer as correct, if not let me know!
Hey Jonathan Im trying out various macros, to be able to import multiple excel files at once.Therefore to my knowledge, im not able to specifi sheet name?
Hi @Hamder83, this error "No sheet specified" comes up because you have multiple sheets on your file and the macro is being applied to only one sheet.
The solution is to have one sheet per .xlsx file.
Hope this helps.
Hi Ive just tried a sample of 5 files, all with just 1 Sheet, and it still doesnt work. Do you have a macro you know works, with importing multiple excel files at once?
Is there the potential to input the sheet names into a control parameter? And convert the workflow into a batch macro?
This link has a useful file that works. Unfortunately, I can't share the files I have as a sample but this link should help you achieve what you are looking for.
Here are some screenshots that may be of help to you.
Workflow with the Macro attached
This is inside the Macro (use one of the files you have in the folder)
Configuration of the parameter
This link is also useful