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

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