Import Different Excel file format and Subfolder in Alteryx

[SH_94]

Hi Community,

May i know how to import different excel format which coming from different subfolder into the Alteryx ?

Any Macro recommended which can be used under Alteryx version 2019.13?

As I not familiar with the Macro, can someone please guide me on how should i modify marco and locate my folders if you are sharing the macro ?

Many thanks for your helps

[pedrodrfaria]

Hi @SH_94 

You can use the WF below. I attached the Macro.

Both are for the 2019.1 version.

[SH_94]

Hi @pedrodrfaria ,

Mean that one macro can only be used for one excel format?

May i know how to change the error of the entry point is not valid?

Thank you

[SH_94]

Hi@ pedrodrfaria,

I encounter the error as shown in the screenshot below ? Could you please advise me how should i proceed to clear the error?

[pedrodrfaria]

I attached one for CSV

To change the macro, open the macro and replace the file used inside of the macro with one for different types of extensions and then save these different versions of the macro

[SH_94]

Hi @ pedrodrfaria,

May i know if the marco work for xlsb format as well?