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.