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

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

Bring in files.yxzp