TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)

Please be sure to mention the version of Office you are using when you send your question.

I answer all e-mails that I receive via this form, as long as they are polite :)

Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.

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!