Microsoft Word VBA to save as prompting user to enter file name & path

[Claire Jackson]

Hi,

I have a word template document with a userform which populates several bookmarks. What I need is a simple code that upon populating the word document from the userform via the command button click it then asks for a new save location for the normal word document and then closes the template without saving.

I know it's a basic question but for the life of me I can't find the solution?

Please help?

 

[NdNoviceHlp]

HTH. Dave

Application.FileDialog property (Word)

Office VBA reference topic

docs.microsoft.com

 

[Macropod]

If you are actually using a Word template they way Word templates are supposed to be used, the user will have little choice but to save the new document without affecting the template.

 

[Claire Jackson]

I get that but do you have the code anyway?

 

[Macropod]

It can be as simple as:

Application.Dialogs(wdDialogFileSaveAs).Show

You cannot close the parent template while to document remains open. Word does that automatically when you close the document.

 

[Claire Jackson]

Excellent, thank you so much