Import and Combine xlsb file from multiple subfolder

SH_94

Hi Community,

May i know if anyone have the macro that can read the xlsb file from multiple subfolder and import them into the Alteryx whereby i plan to combine them together in Alteryx as they have the same schema.

Appreciate if you can provide the screenshot on how to modify the macro so that the macro will identify and read the subfolder correctly. It would be great if anyone have the macro which cover importing and combining the data in xlsb file.

pedrodrfaria

@SH_94 

Please share the fullpath you are trying to read when you received the error that were having with the macro.

Did you try what I mentioned? Moving the files to your desktop and reading them from the desktop instead of a specific folder because the error could be related to the full path being too long.

Pedro.