Macro to Save file with date/time stamp

[tt388]

Hi all VB Experts,

I have a file located at C:/Report.xls

I would like to have a VB code that can first save file at this location. Meanwhile, an extra copy will be saved under C:/Archive/ . The second file needs to be saved with Date and Time stamps.

Thanks...

[solnajeff]

Hi

Attached is an example for you to try.

When closing the file it will automatically be saved at its current location, then a copy will be saved in the directory "Archive", this will be created automatically if it does not exist.

The code is in "This Workbook" and can be amended as necessary.

Regards

Jeff

[tt388]

Thanks. but...

I do not want to put the file path, date and time on the worksheet. I want to code the path in the VB code,and save the file at the path with current date/time stamp...

[James580]

TT388

I built something like that, try the code

I hope this helps

Please Login or Register  to view this content.

[tt388]

James580

Thanks. It is close. But I do not have the file name on the my spreadsheet. I want to save a copy using the orginal file name and adding date adn time stamp. For exmaple,

original file location C:/Report.xls
acrive copy location C:/Report/Archive/Report_YYYYMMDDMMSS.xls

[royUK]

Try this

Please Login or Register  to view this content.

[tt388]

royUK,

Thanks. There is an error when I run the script.

Run-Time error 13, Type mismatch

VBE shows an error on this line:

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.