D
douglascfast
Anyone, and everyone
I have a macro to save my spreadsheet. (I am saving it several times
with diffrent names based on the data the macro pulls)
The code is as follows:
ActiveWorkbook.SaveAs Filename:= _
"I:\Commercial\0607\BVS\Master Bvs\ANU20.xls",
FileFormat:=xlNormal _
, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, _
CreateBackup:=False
Heres the trick,
When it runs through its 5 times, every now and then I get a error 1004
message and the file is not saved. Now this can happen at any stage of
the macro and has no rhyme or reason (That I can see)
What do think? Is there a better way to do this?
Doug
I have a macro to save my spreadsheet. (I am saving it several times
with diffrent names based on the data the macro pulls)
The code is as follows:
ActiveWorkbook.SaveAs Filename:= _
"I:\Commercial\0607\BVS\Master Bvs\ANU20.xls",
FileFormat:=xlNormal _
, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, _
CreateBackup:=False
Heres the trick,
When it runs through its 5 times, every now and then I get a error 1004
message and the file is not saved. Now this can happen at any stage of
the macro and has no rhyme or reason (That I can see)
What do think? Is there a better way to do this?
Doug