Multiple sheets Multiple Excel files macro issue

[PuffinPanic]

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:

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 

[gabrielvilella]

Hi @PuffinPanic, try this.

[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:

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

[gabrielvilella]

I don't have my file path within the macros, the only place is on the Directory tool. You should be able to run the workflow with those macros, just by updating the Directory.

[PuffinPanic]

You're right, that's what was wrong.

However, when I have opened the package I'm getting 'The entry point is invalid' and broken links. Not sure what tools are supposed to be in there.

[PuffinPanic · Accepted solution]

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

[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.