Change File Name without losing formatting for excel sheet with many tabs.
- 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
Using a template to append data to multiple tabs with formatting. Is it possible when it finishing writing that I can change the file name? The WF does not have to be connected, it can be a separate process.
Formula tool has not done it for me. CMD tool, I don’t believe I can send a rename-item script to rename.
Directory tool maybe, I haven't been able to figure this tool out.
Solved! Go to Solution.
- Labels:
- Macros
- Run Command
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Warcry
I think we can use Run Command to change the file name after output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Warcry
I think that @Qiu already has you covered, but here is a similar scenario I answered awhile ago. This solution uses a dynamic input and list of filenames to be generated, copies and saves each file to an output folder, and finally runs the workflow and outputs the data to each newly created file.
Thanks!
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This works too. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Quick and short solution that I can easily attach to any workflow. Perfect!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to helo and thank you for the accept mark. 😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
Even I'm trying to apply this solution to my workflow, but I'm getting an error: The file "C:\Users\........\Temp\11\RunCommand.bat" is not a known format.
Can you guys please help.
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Found out the reason why for my above query.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for sharing the above post and I tried your workflow and steps. But, I'm getting the below two errors.
I pulled the path using the "FileGetDir()" formula in the formula tool.
On the 2nd error, the excel file is not open but i'm still getting this error.
Any suggestions.
Regards,
Raghu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@raghusrealm
if possible, can you upload your modified version? 😂