Alteryx designer Discussions

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

Importing multiple excel files

Highlighted
10 - Fireball

@DanM 

 

I have a directory tool connected to the Macro.  The Macro sample file is pointed to the excel file.  Table Query is set to the table name.  Option 5 is set to Full Path.  The Action Tool is set to the File Value.  I get no errors when I run the sample file in the macro.  But, I get no sheet specified when I try to run the macro in the workflow. 

 

Thanks

Highlighted
10 - Fireball

@DanM  I have it partially working.  But now I have a new problem.  The output of the macro is assigning the sample filename across all filenames. 

Labels