Is there a way to force users to save the file with a specific filename? A
template will be circulated and with multiple files expected in return, the
macro I have to pull all the data requires the files be named specifically.
By the same token, depending on which area fills out the template, I have a
specific name to use.

Any help would be appreciated!

Create a dialogue form
Add a List Box to the form with the areas as selection values or use
radio buttons
Add a Save button to the form
On SaveButtonClick
Check that a List value has been selected
Prompt the user to validate the list area if he screws up
When list selection is correct:
Use conditional If's or a Case Statement to save to the proper file
based on the List value


jen wrote:
Is there a way to force users to save the file with a specific filename? A
template will be circulated and with multiple files expected in return, the
macro I have to pull all the data requires the files be named specifically.
By the same token, depending on which area fills out the template, I have a
specific name to use.

Any help would be appreciated!