Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save Excel subtotals without saving hidden (Level 3) r | Excel Worksheet Functions | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
Excel marcos firing on file save as but not file save | Excel Programming |