Any way to "Save As" without setting the archive bit on original file

I

inaz

I use a program that sends new or modified files, then clears th
archive bit.

My problem is that if I modify the master file and do a "Save As"
Excel sets the Archive bit on the original file - even though th
original file was not modified.

I don't think there is a solution, but thanks for any help :
 
J

Jim Rech

A new file should always have the archive attribute set since it has not
been backed up. You might try SetAttr with the file after it is saved:


SetAttr "c:\book1.xls", vbNormal
 
Top