Wednesday, July 22, 2009

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)