Set filename when saving a file created from a template 1

[PPettit]

When you're trying to save a file created from a template, is there a way to set the file name that you want to use rather than using the auto-incremented file name?

For example:
I have a template named "MyTemplate.xlst". When the user wants to create a document using this template, the new file is automatically called "MyTemplate1". If I try to save this file, I get a "Save As" dialog box with "MyTemplate1.xlsx" defaulted in the file name field.

I want to save the file using a name based on some fields that the end user will fill in. Is there a way to set the file name to whatever I want when the "Save As" dialog box comes up?

 

[PHV]

Build the desired filename into a string variable and the use the Workbook.SaveAs method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PPettit]

Thanks, PHV. That appears to be just what I needed.