Word VBA Question - Using Custom Dialogs

[DetroitDavid]

I have a template in word, saved as Hort.dotm

Whenever I launch this a File > New > My Templates > Hort dotm, I’d like to open a custom dialog (which I can see how to do in many places on the web).

I need to find a good beginners tutorial on creating elements into this new dialog, storing the input, conditionally using the value to insert text (pre-formatted blocks?) in specific places in the document, then launching the File > SaveAs dialog with a filename derived from two of the variables and the date.

E.g. one variable example would be strLastName; so the new file would

1. Open (document1.docx)
2. Launch dialog
3. Collect information
4. Store these values as variables in code
5. Fill-in the document with variable text at specific bookmarks
6. Launch SaveAs with the default set to a specific path, and a suggested filename like:
7. • strLastName & “ – “ & Address & strAddress2 & “MI”
   • DetroitDavid – 3033 Harrison Ave Trenton MI

Can anyone point me to a good tutorial on this?

TIA - DD

 

[Macropod]

I don't know of any tutorials on this, but I very recently provided help on similar issues here: How to invoke the macro correctly in the workflow and here: creating a new TITLE property from text already within document

 

[DetroitDavid]

Excellent, thanks I'll review