save currently open file appended with today's date

**roothog** · 01-03-2011, 07:51 PM

I'm trying to write a macro that will save my currently open file ("autoname.xlsm" and always kept void of data) appended with the current date (i.e. "autoname_01/01/11.xlsm") after data is entered and saved to the same folder. I've had zero luck.

Any help would be appreciated.

Thanks,
roothog

**stanleydgromjr** · 01-03-2011, 08:09 PM

roothog,

You should be getting an error that you can not use "/" or "\" in a filename.

Try:

autoname_01_01_11.xlsm

or,

autoname_01012011.xlsm

**roothog** · 01-04-2011, 12:56 AM

That would be one mistake I made! I've read/tried several similar ideas from this forum but still can't make it work.

**stanleydgromjr** · 01-04-2011, 03:56 PM

roothog,

Can we see your macro code?

At the beginning of your posted code, enter the following without the * character: [*code]

'Your code goes here.

At the end of your posted code, enter the following without the * character:
[*/code]

**roothog** · 01-05-2011, 06:48 PM

I have tried the following from a Jerry Beaucaire post a few months ago (changing path\filename only) and it should be exactly what I need. But it doesn't save any new file at all for me.

Please Login or Register  to view this content.

**stanleydgromjr** · 01-05-2011, 08:50 PM

roothog,

The code worked for me with a slightly different path, using Excel 2007.

When you did a File SaveAs, the file should have automatically been saved with the original filename and the new extension.

Did you check the directory/folder c:\2011\ to see if the file had been saved?

Did you check the filename in Excel at the top of the computer screen?

You can send JBeaucaire a Private Message requesting help.