Activeworkbook.SaveAs "C:\MyExistingFolder\" & Format(Date, "mm-dd-yyy")

--
Regards,
Tom Ogilvy

"Kstalker" wrote in
message ...

Norman.

Worked well thanks.

Now need to direct the newly created workbook to a specified location.
Have read alot of threads but my basics are letting me down. Or lack of
them.

Regards

Kristan


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile:
http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=383762