Archive Attribute Excel 2003

I need to know more about this attribute. I have several .xlA files (not installed as 'AddIns' in Excel) containing VBA code; these files are digitally signed and run on a network. It makes sense to me that Excel would mark these with the 'Archive' Attribute.

The above .xlA files update (bring in new data and save the revised .xlS files), on a daily basis, two .xlS data files. It puzzles me that Excel also marks these with the 'Archive' Attribute. There is zero VBA code in these .xlS files.

Thanks in advance,
Chuckles123

Hi Chuckles123,

Chuckles123 wrote:
> I need to know more about this attribute. I have several .xlA files
> (not installed as 'AddIns' in Excel) containing VBA code; these files
> are digitally signed and run on a network. It makes sense to me that
> Excel would mark these with the 'Archive' Attribute.
>
> The above .xlA files update (bring in new data and save the revised
> xlS files), on a daily basis, two .xlS data files. It puzzles me that
> Excel also marks these with the 'Archive' Attribute. There is zero
> VBA code in these .xlS files.

The Archive file attribute is set when a new file is created. It should be
removed by any application that does a backup of the file. Hence, the
Archive attribute is more to tell backups programs whether or not a file has
been backed up, not whether or not it contains code.

--
Regards,

Jake Marx
www.longhead.com


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

Thanks for the education.

I was thinking that the 'Archive' Attrubute had more to do with the existence of the digital signature than whether the .xlS files contain VBA code. But you straightened me out.

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

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 am also assuming that whether there is such a "check-mark" would have zero impact on any of my macro crashes.

Just looking for confirmation of the above.

Thanks in advance,
Chuckles123

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]