Batch Macro Input Multiple Sheets from Excel File with Differing Schema

ractony7

Hello Community,

I have an Excel file with multiple sheets.  I already know how to import all of the sheets when they have the same schema.  My problems is that many of my sheets have different schema. 

The column headers are in different order on some of the sheets. 

I can not share the excel file because it has personal information in it.  If anyone has any information that might help that would be amazing.  The macro I have will input some of the files, but only those with the right schema.

JosephSerpis

Hi @ractony7 have a look at the solution from this post it uses two batch macros one to get the sheet names and will deal if they are different schemas and then another batch macro to deal with the data from those sheets and should handle the difference in scheamas as well. It's also worth pointing out to look at the configuration of the Batch macro in the Interface Design - Properties option as this decides the Output mode which affects how it handles different scheamas and data in different postions.