S
stainless
I have created an Excel 2003 template that has a user form for input
of text fields. These text inputs should then be used to replace texts
within the excel template to create a new excel document.
I understand how the user form should work and how to replace the
texts in the template but don't understand the basics in vba of:
1. how opening the template will automatically open the user form
2. how to create the excel document from this
3. how to close the template so just the new excel document is open
Given I have MyDocument.xlt template with the worksheet "Certificate"
containing my template with the text to be replaced, how do I do the 3
actions above to create a new excel document MyNewDocument.xls with
the altered sheet "Certificate"?
Hope this makes some sense
Mark
of text fields. These text inputs should then be used to replace texts
within the excel template to create a new excel document.
I understand how the user form should work and how to replace the
texts in the template but don't understand the basics in vba of:
1. how opening the template will automatically open the user form
2. how to create the excel document from this
3. how to close the template so just the new excel document is open
Given I have MyDocument.xlt template with the worksheet "Certificate"
containing my template with the text to be replaced, how do I do the 3
actions above to create a new excel document MyNewDocument.xls with
the altered sheet "Certificate"?
Hope this makes some sense
Mark