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