Designer 19.3 - Import multiple xlsx

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?

Input

Accepted answers

mmishal001

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

All comments

Jonathan-Sherman

Hi @Hamder83.,

Could you check the input tool section (3)?

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

Hamder83

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?

mmishal001

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.

Hamder83

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703