Trying to save a worksheet
I would modify Frank's macro to put the year in front as
in YYYYMMDD_hhmmss in your backup.
That would make sure you know when you created it rather than
just going by what you see in the directory which is usually the
date modified.
"Frank Kabel" wrote in message ...
Hi
try something like
sub save_it
dim fname
dim fpath
fpath="c:\temp\"
fname=Format(now,"MMDDYYYY_hhmmss")
activeworkbook.saveas fpath & fname
end sub
|