« Tips and Tricks for Using Basic Word VBA Every Day: It's Much Easier than You Think! (Level 300) | Main | Use PowerPoint's Recolor Picture Tool for Embedded Word Tables »
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!
Posted by Stephanie
TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt/mt-tb.cgi/51
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)
Comments
Hi Stephanie! Webcast was nice - I expected to be more advanced (well, is was *basic* Word VBA was it :)) - is there any Advanced Word VBA webcast planned ?
Posted by: Peter Jaušovec | February 25, 2005 03:22 PM
Thanks for your post, Peter!
My planned webcasts for the next couple of months aren't VBA -- but I certainly hope to do more ... and will keep you posted on the blog :)
Stephanie
Posted by: Stephanie Krieger | February 25, 2005 04:42 PM
Hi Stephanie. I just did your webcast on VBA for Word. It was excellent and a great summary. Thanks a lot. It saved me a lot of time and was very informative.
Posted by: Owen Harris | September 18, 2005 10:27 PM
Thanks, Owen! I'm glad it was helpful :)
Stephanie
Posted by: Stephanie | September 20, 2005 04:05 PM