If anyone else has any information on Office Automation, and
specifically how it fits into Win32OLE, I’d really appreciate
it - what
I’d really like to have is a “canonical” list of all methods for each
available Office module. But I haven’t found anything close to that
I’m using WIN32OLE to control Adobe Photoshop and Illustrator.
The way I went about to see which properties and methods to call, was to
load excel, open VBA inside Excel (Alt+F11), then add a reference to the
library I want to use from the Tools menu. Then I can browse the library
in the object browser (F2).