Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Where did the "Excel File Opener" macro go??

tom_dup_567
7 - Meteor

I have this macro in Designer and I'm trying to direct others to it for download, but I cannot find it. Does anyone have a direct link to it?? 
(this lets you load Excel workbooks with multiple tabs so long as they are all formated the same - very useful)  Thanks...

3 REPLIES 3
patrick_digan
17 - Castor
17 - Castor

@tom_dup_567 I think it could be in one of 2 spots. Open a workflow that uses that macro. 1) Go to Options >>> advanced options >>>> workflow dependencies. Click on show individual tools in blue at the top. If you see Excel File Opener, it should then have the filepath. If it's not there, then 2) Options >>>> User Settings >>> Edit User Settings. Click on the last tab macros. It will list macro repositories that you have setup. Excel File Opener should be in one of those folders.

 

Let me know if you can't find it!

alexandramannerings
8 - Asteroid
MichaelSu
Alteryx Alumni (Retired)

that's it, thanks @alexandramannerings 

Labels