Macro Help for Saving a file
 

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

Macro Help for Saving a file
 

would it relate to the file name you are trying to use (possibly
illegal?)

Macro Help for Saving a file
 

Don't Think so. Sometimes the first 4 of these run and it fails on the
5th. Somethimes it fails on the first. They are all saved to the same
area just under different names.

Macro Help for Saving a file
 

If, after the failure, the workbook ceases to be able to be saved "anywhere",
then your trouble may be coming from network hits occuring at random times,
not really even related to your macro.....

One thing you might try is to put this macro in a TEST workbook and see if
it reacts the same, saving to your local drive directories rather than the
network.

Vaya con Dios
Chuck, CABGx3

" wrote:

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