Thanks to everyone who took the time to attend yesterday's webcast on the basics of using Word VBA as an everyday document production tool.
As promised, I am including two documents here that you can download -- containing the code I demonstrated yesterday as well as a bit more ... and explanatory notes added in the code. Also posted here is the accompanying sample document that the macros were used to format (Quarterly Report.doc).
To make this easier for those who are brand new to VBA, I added the demo code to a document to post it here, rather than just posting the stand-alone module file. This way, you can open the Word document (called Sample Macros.doc) and get access to the macros through the module I added to that Word document.
Click to download:
Sample Macros.doc
Quarterly Report.doc
Note that you will need to set macro security to Medium or lower in order to enable the macros in the sample macros file. (I don't recommend setting it lower than medium.) If set at Medium, you will be prompted upon opening the file -- click to Enable the macros when prompted.
-- If you would like to save the code module as a standalone file, right-click on the module (in Project Explorer -- which, by default, is the top left panel in the Visual Basic editor) and select the option to EXPORT -- then choose a location for saving the module file.
-- You can also import modules into open projects by right-clicking on the project name in Project Explorer and using the IMPORT option to select your file.
-- One other handy note -- you can copy modules between open projects just by clicking and dragging the module from one open project to another in Project Explorer.
I hope everyone enjoyed the webcast and I hope that, if you haven't used VBA before ... perhaps this gave you a bit of inspiration to give this incredible tool a shot!
Have a great weekend ... and feel free to post questions as comments here, on anything covered in the webcast!