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

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

Thanks in advance,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=54048

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 th
existence of the digital signature than whether the .xlS files contai
VBA code. But you straightened me out.

Occasionally, my macros crash. The most common problem involves th
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 hav
zero impact on any of my macro crashes.

Just looking for confirmation of the above.

Thanks in advance,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=54048

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]