View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Excel to save as a hidden file?

Not with the Excel.SaveAs.
But after the save and close, you can use SetAttr()

However, if that file is visible will depend on the user's Windows settings.

NickHK

wrote in message
ups.com...
Ok heres the thing...I can manage to get Excel to save a file as
"whatever.whateverextension" but I am wondering...it is possible to
set an attribute to the "Save As" macro to save as a hidden file in
Windows, so someone couldn't see it?