Excel File Opener Macro

[kkaplan1]

Hello,

I am trying to use the Excel File Opener Macro that I pulled from the Community. I have never had a problem in the past, but now when I go to run it, I am getting an error that says "Tool #5: Record #1: Tool #1: Set up connection to use the tool and Tool #5 The output connection "Output" was not valid. The strange thing is if I go and run the macro on it's own, I am not getting any errors. Is there a reason that this would be happening? It seems my macro is working and pulling the right results, but I cannot get it to pull into the actual workflow.

Thank you!

Kandace 

[jshe3757]

Hi Kandace,

I'm running into exactly the same issue for this macro. May I check if you happened to have resolved it?

Best,

Sunia

[OTrieger]

@kkaplan1 
One thing that can impact macros is the AMP engine. Check if it is ticked or not, and try to untick it or tick it based on you current setting.

[OllieClarke]

Hey @kkaplan1 

So the error message says that the issue is in Tool#5.
Tool#5 is a macro though, so if you open it up, the actual issue is in Tool#1 (within Tool#5).

My guess is that this will be an input data tool, which reads in a template file, but Alteryx can no longer find the template file so it's throwing this error. If you dive in and point the tool at a (I'm guessing) excel file, then that might sort the issue.

Let me know if that helps,

Ollie