Hi Community,
May i know if anyone have the macro to read the xlsx format with the criteria below:
1. Multiple tab in one excel file
2. Different schema between one excel with another excel file
3. Multiple excel file in one folder.
My current macro only can perform the step 2 and 3.
Is there anyone have the marco ready for the above criteria?
Many thanks
hi @SH_94
You already have type 1 macro (multiple tabs in one excel file) working, so it is a matter of updating the "Action" Tool so that
you update the FileName instead of changing the TabName in the path.
Check this out for the ultimate guide in reading multiple tabs/files from Excel:
Dawn