What I'm after is a template which opens up a userform and the user inputs a bunch of variables to populate the worksheet. One of these variables is
"This is _x_ in a series of _y_ forms"
basically, we want this form to generate y number of copies of itselt. The catch is, each time it opens itself, we are getting a whole new set of variables. Also, we want this to run from a single template.
Check this code out:
If MainForm.txtY > MainForm.txtX Then
MainForm.txtX.Value = MainForm.txtX.Value + 1
Documents.Add Template:= _
"C:\Documents and Settings\Garrett\Desktop\Work Order Template.dot", _
NewTemplate:=False, DocumentType:=0
Documents(1).Activate
Call generateDoc
End If
Ok well you caught me... it's a word document, but the same principles apply.
Can someone point me in the right direction please?
Thanks in advance.
Bookmarks