Useful VBA Code for Office Applications

The following recent blog posts provide some very useful code:

• From VBA Tips & Tricks How to save a Word 2007 document as a PDF
  
  
• From Daily Access Tips A generic form data validation function. The sample code calls the function from the form's VBA module's OpenForm event. You could streamline the call by using a no-module form where the function is assigned to the OnOpen Event in the form's properties dialog: =SetValidatorEventHandlers(Me)

How do I… Transfer data from a Word form to an Access database?

This is an excellent article from TechRepublic.com blogger, Mark Kaelin, on how to use a Word form to collect data for an Access database, even when the user's PC does not have Access installed.