One file but different tabs - Batch Macro

[Sarath27]

Hi All,

Please guide me on this, I have a mapping file which has 10 different sheets.  I am using this mapping file for 5-6 times using input tool, which consumes time and also very manual.

I believe it could be automated using a batch macro where I can use any sheets from that particular file without bringing input tool everytime.

Thanks,

Sarath

[jdminton · Accepted solution]

Are the files set up with the same schema (field headers, data types within the fields, etc.)? If so, you can use dynamic input. If not, you will need a macro to bring in the data. Inside the macro, you will want to create a batch macro that does not use the first row as field names. I would also suggest bringing in the full path filename for each tab so you can identify the records after they are brought in. The macro should be like this