By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

¿How can I edit the name of a file I want to export to Excel?

P: 1
I need to save the same file each day, but each day I have to manualy edit the file´s name to the format : "[FileName]_DD\MM\AAAA_HH:MM:SS.xls"

Truth be told I´m done with it, I just whant to know how to create a Macro that saves the file with the systems date, or any other forms that saves me time each day.

Thanks in advance.
Mar 26 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,492
You should be able to save it as a different filename when you save it. What is the code you currently use to save the file?
Mar 26 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.