Hi,

Chuckles123 wrote:
Occasionally, my macros crash. The most common problem involves the
data files. One data file is saved daily by the following code:

When you say "crash" - do you mean a true crash of Excel, or do you just get
a runtime error?

oWBook.SaveAs _
Filename:=strFileName, _
FileFormat:=xlNormal, _
Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False

The other data file is saved merely by: oWBook.Save.

I am assuming that the above code will always result in the 'Archive'
Attribute being "checked", regardless whether there was a "check-mark"
prior to the save command.

I believe the saved file will always have the Archive atrribute set, but
you'd have to test to verify.

I am also assuming that whether there is such a "check-mark" would
have zero impact on any of my macro crashes.

Right.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]