Excel to save as a hidden file?
 

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?

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?

Excel to save as a hidden file?
 

On Feb 13, 12:48 am, "NickHK" wrote:
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?- Hide quoted text -

- Show quoted text -

Thanks Nick! I managed to figure it out after messing around with it
but I appreciate the response...maybe someone else will need this some
day =)