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