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