How to use the same macro for a csv/xlsm file with same schema in Alteryx Designer? Help

Question

Hi there, I wanted to know how I can use the same macro which I have created (using a csv file template) with either csv or xlsm source input.  I can use the macro for a csv file but it is throwing an error when I am trying to use it for a xlsm file.

I have the input file - full path name , sheet name, file extension name columns connected with the macro and inside the macro I have used one the Control Parameter and in Action - changed the Entire Full Path.

How can  I use the same macro for csv as well as xlsm input file with same schema and sheet Name.

DanM · Answer

@AbhirupMukherjee09 using an interface tool of your choice to update the file type, you should be able to find the file type in the Action tool to update if it's connected to an Input tool. Seeing the macro would be helpful if you can share it.