Multiple sheets Multiple Excel files macro issue

Hi,

I've been trying to use the Multiple sheets multiple excel files macro found elsewhere on here, but having opened the package and got it into designer, when I try to run it I get this error:

Multiple Sheets Multiple Excel files.png

I haven't made any changes to the macro/package (redownloaded it to check), just opened it and run it, and I consistently get this error.

The file path is correct, but it fails to find it when it goes through the macro.

Any suggestions please?

Thanks

PuffinPanic

Developer

Input

Error Message

Batch Macro

Accepted answers

PuffinPanic

So, I'm not sure why this has worked, but, a combination of "[FullPath]+"Sheet1$"" in the Full path formula tool in the main workflow and making sure the expected sheet name is on the 'Replace a specific string' value in the format <full path>|||`Sheet1$` in the macro seems to have made it work.

I'm not going to question why, but if anyone knows and would like to explain I'm all ears!

Thanks for trying to help @gabrielvilella

PuffinPanic

All comments

gabrielvilella

Hi @PuffinPanic, try this.

Read Excel Sheets.yxzp

PuffinPanic

Thanks for this.

When I import it, it has the filepath set for your user - fair enough - I've edited this in the dependency properties to my folder.

I've tried a couple of different folder locations, but get this message in the Test Error box in the workflow dependency properties:

directory does not exist.png

Clearly the directories I've tried do exist, because I've browsed to them. I'm guessing this is what's causing the issue with the macro.

It's odd that inputs using a data input tool work fine, but trying through a macro is failing.

Any further suggestions would be appreciated.

PuffinPanic

I'm not going to question why, but if anyone knows and would like to explain I'm all ears!

Thanks for trying to help @gabrielvilella

PuffinPanic

gabrielvilella

When importing the package, you need to click yes and import on the messages that appear when you open it in Alteryx.

You need the sheet name with the full path because the macro is updating everything. If you don't have all the information it is expecting it will fail.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703