ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Save file name with version number (https://www.excelbanter.com/excel-discussion-misc-queries/74590-save-file-name-version-number.html)

ianh

Save file name with version number
 
Is it possible to have a macro that saves a file name with a date and version
number included ?

For example Myfile v.01.xls is saved as MyFile v.02 ddmmyy .xls

Chris Marlow

Save file name with version number
 
Hi,

Search for the thread;

MACRO VBA TO SAVE EVEN IF FILE EXISTS

in Excel programming.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"ianh" wrote:

Is it possible to have a macro that saves a file name with a date and version
number included ?

For example Myfile v.01.xls is saved as MyFile v.02 ddmmyy .xls



All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com