Hi i have a procedure that copys data into a workbook from external
locations, i need to save this workbook under todays date to create an
audit trail. I'm having problems doing this as running the code brings
up error 1004 - excel cannot access the file because doesn't exist,
used by someone else.

What is wrong, code is below, thanks

Dim fname As String

fname = "Mainfile-" & Format(Date, "dd/mm/yyyy")
ActiveWorkbook.SaveAs Filename:=fname
MsgBox (fname)


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=539204