code to SAVE
Hi experts,
using Excel '03...
My company is trying to save its xls documents (and other MS docs) in
a particular format; e.g., Program_Desc_Date_Initials.
Is there a way to code Excel (possibly placing the code in Book.xlt)
that prompts/asks the user (when the user executes SAVE or SAVE AS) to
enter the appropriate program, description, date, and his/her
initials. I'm thinking four input boxes (one after the other).
This data from the user would be concatenated and would form the file
name (now located in the Save As dialog box). The user would then
simply choose a location.
Thoughts?
alex
|