One file but different tabs - Batch Macro
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
 
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)