View Single Post
 
Old 01-18-2011, 07:42 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi gburya,

I have no idea what that message means.

After adding the macro to the VBE, you can exit that and run the macro by pressing Alt-F8 and selecting 'CertificatePrint'.

A couple of points to note:
1. I've assumed the SEQ field is the first field in the first textbox in the document. If it's not, you'll need to adjust the index numbers accordingly.
2. In Word 2007 & later, if you put the macro into your 'Capital_Unit_Certificate' document, you'll need to save the document in the docm format and you'll need to enable macros whenever you open the document if you want to print the certificate. Alternatively, if you add the macro to Word's 'Normal' template, the macro will always be available (to you only) an you can keep the document in it's docx format - plus you won't get macro warnings every time you open it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote