How to add new sheet dynamically to multiple files in a directory
- 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,
I am looking to create a workflow that allows the user to use a interface tool which passes through a sheet name to multiple files on the shared. I am able to create the interface tool part but having a hard time figuring out the best tool to use to create a new sheet on all the files in a folder.
Any help would be greatly appreciated.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you adding the same data/sheet to every file as well?
Using the output of a directory tool and appending the full path with sheet name appended to it to use in your output tool should work.
You could also come up with a batch macro that passes the full path of every file in the target directory and the new sheet name to it and outputs that way.
The batch macro is probably your best bet since joins or appends can get nasty depending on the number of files and rows of data involved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes i am adding the same sheet and sheet name to all the files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes i am adding the same sheet and sheet name to all the files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you ! This is exactly what im looking for.
![](/skins/images/4AD62B665AB5C9F49FE7F2C9A79805ED/responsive_peak/images/icon_anonymous_message.png)