code to SAVE
yes, you have the right group. and i know what you describe can be
done within the macro - don't know about using the saveas dialogue or
before_saveas event but i suspect that can also be done, too (just
don't know how). as an example:
sProgram = inputbox1.value
sDesc = inputbox2.value
sDate = inputbox3.value
sInitials = inputbox4.value
wb.SaveAs Filename:=sProgram & "_" & sDesc & "_" & sDate & "_" &
sInitials & ".xls"
might get you started.
sorry can't be of more help.
susan
On May 15, 10:27*am, alex wrote:
On May 14, 1:07*pm, alex wrote:
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
Can someone tell me if I posted this question to the wrong group?
Thanks,
alex- Hide quoted text -
- Show quoted text -
|