All our letter templates open with a UserForm that the user populates; one of the inputs dictates if the letter is going overseas, which adjusts information within the template such as our telephone number (it adds +44 to the beginning of the number). One particular template then adds a “process document” using this code:

The “process document” provides details of what we are going to do and currently does not change; however, it does include several telephone numbers. I have now been asked to update the document so that the telephone numbers are amended dependent on where the letter is being sent



When this opens a UserForm appears and the user chooses one of two CommandButtons which will then amend the telephone numbers.

My question is, is it possible for the first document to launch the “process document” and then either select the appropriate CommandButton or to negate this stage altogether and update the “process document” without a UserForm?

It's certainly possible, but it would be much easier to provide specific advice if you could attach a document to a post with some representative data (delete anything sensitive). You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Here is the 'cleaned' documents, I have removed a large amount of data from the document. However, the relevant parts should all be there.

Essentially, if ComboBox 1 = "UK" then I want VBA to open the "process document" and select "CmdUK" from UserForm "Process" and if ComboBox 1 <> "UK" then I want VBA to open the "process document" and select "CmdNUK" from UserForm "Process".


Many thanks for your help!

Attached Files

	Cleaned VBA Document.doc (60.5 KB, 13 views)
	Process Document.doc (38.5 KB, 14 views)

All you need do, then, is add bookmark to the “process document” in front of one telephone number, and cross-references to that bookmark in front of the rest of the telephone numbers, then update the bookmark with the country code, followed by .Fields.Update. However, there is an issue with the way your code currently 'updates' bookmarks. Instead of updating them, it merely inserts text after them. To update a bookmark you should use code like:
which you would call with code like:
Call UpdateBookmark("Address1", vbCrLf & ComboBox1)
Similarly, for adding & updating your “process document”, you might use code like:
Where "IDC is the bookmark name in your “process document”, (IDC = International Dial Code).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for your update Paul. However, the bookmark updating is not the issue here. I need the first document to add the "process document" then select the appropriate command button.

To do what you want would probably require you to:
1. create a document variable or custom document property in the template
2. when you create a new document from the template, update the new document's copy of the document variable or custom document property
3. have the code in your userform read the document variable or custom document property in the activedocument and check the appropriate button programmatically.
I'm not sure whether the AutoNew macro you now have would fire before the document variable or custom document property is updated. If it does, you wouldn't be able to use the AutoNew macro; instead you'd need to update the document variable or custom document property then call another macro to load the userform via Application.Run. For example, in your 'Cleaned VBA Document' document:
where 'LoadUserForm' is the macro name in the 'process document' template.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]