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

  • Thread starter Thread starter inaz
  • Start date Start date
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 :
 
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
 
Back
Top