Couple of options:
- First, Andy's right - make sure all your Excel help files are loaded
during install.
- Second, msdn.microsoft.com - search for something linke "excel vba" or
"excel object model", and that should get you to the online doc's, where
there's lots of examples also.  You'll probably have to register, first. Its
free, and I'd recommend it for the resources anyway.
- and/or Third, browse the object model from within Excel itself.  Create a
new macro, which will bring up the Visual Basic for Applications interface.
Hit F2 to bring up the object browser.  This will show you the entire object
model in a heirachical form, and just hit highlight a object/method and hit
F1 to bring up the help on it.

Happy COM'ing!

- Rick

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Andy
Robinson
Sent: Thursday, May 09, 2002 12:40 PM
To: Ken E. Waters; active python
Subject: RE: com and excel documentation


> i'm trying to figure out how to use com to control excel,  i've gone
> through several examples and it seems easy, but i can't find a complete
> list of commands.  does anyone know a good place to get the com commands
> from?
The Excel Help files.  When you (re)install Office, make sure
you go to the advanced options and ask for all the VBA
documentation.  If you then go into Excel' macro editor
you get full reference to the object model.  Likewise
for the other Office apps.  If you do a 'typical' Office
install you won't have the docs.

Best Regards,

Andy Robinson


_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython


_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython

Reply via email to