What I'm after is a template which opens up a userform and the use
inputs a bunch of variables to populate the worksheet. One of thes
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 se
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 Orde
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 principle
apply.
Can someone point me in the right direction please?

Thanks in advance

--
prepotenc
-----------------------------------------------------------------------
prepotency's Profile: http://www.excelforum.com/member.php...fo&userid=2415
View this thread: http://www.excelforum.com/showthread.php?threadid=39537