Quick Tip: Learning the Office Object Model


This is an old one, but still a good one. 

Want to do something programmatically in Word/Excel etc. and don't know how to?  Simply hit Tools/Macro/Record to start recording a new macro.  Perform the action through the UI, and stop the recording.  Then you have sample VBA code in the macro to get you going.

Comments (1)

  1. Stephane R says:

    Will VSTA do this as well?

Skip to main content