Open Multiple Excel Using Macro

[Thordust16]

Hello,

While running a batch macro to open multiple excel files I notice an error message mentioned below.

Few files data is not loading due to this error, any help is appreciated.

[BenMoss · Accepted solution]

Well the problem is informing you of the exact issue, your files appear to very in schema (that be number of columns, headers, header positions or data type).

In a batch macro you can set your configuration to ignore a different schema error in the interface designer.

Alternatively I would just use the macro from this post...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-multiple-files-with-...

Ben