Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save & Save As Question
Greetings,
I have a file named TheBasis.xls. I would like allow a user to append to the name, however, always keep TheBasis as the first part of the name. I would prefer to disable the simple Save command. Is there a way to do this in VB? I was thinking that there may be some way to trap the attempt to Save or Save As, and then go to VB, however, I don't know how. Thanks in advance for your help! Ray |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save & Save As Question
Ray,
Check out the Workbook_BeforeSave event. You can force your required filename (informing the user otherwise they will get confused), save, then cancel the save that excel is waiting to process. NickHK "Ray Batig" wrote in message ink.net... Greetings, I have a file named TheBasis.xls. I would like allow a user to append to the name, however, always keep TheBasis as the first part of the name. I would prefer to disable the simple Save command. Is there a way to do this in VB? I was thinking that there may be some way to trap the attempt to Save or Save As, and then go to VB, however, I don't know how. Thanks in advance for your help! Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
Why system asks me to save change even after I call save method(VB.NET) | Excel Programming |