Transfer DocVariables from one template's userform to another template's userform
If a checkbox on Template1 is checked, then it will open another template by using Applications.documents.add ("c:\template2.dotm")
When template2 opens, I want the textboxes on the userform in template2 to populate with the information from the textboxes on the userform in template1. Basically, both templates use several of the same document variables and I want to pull the inputs from template1 to populate the userform in template2.
Is this possible and, if so, how do I go about doing it?
Thanks for any help!
-- Mike
|