Automation Classes / Methods, overview or list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Does anyone in this forum know where to find either a white paper providing
an overview for Excel automation services. Even better would be if anyone
could tell me where to find a list of all Excel automation classes and
services with their parameters.

In advance thank you very much,
Ole Schjoeth, Denmark
 
If you open the VBA Editor from within Access and while you are in edit mode
in Access, you can go to Tools|References and check the box for the Microsoft
Excel 11.0 Object Library and click OK. This will make available to you all
the OLE Automation classes for Excel. To see a list of the classes and their
associated members and parameters, click on View|Object Browser. Then, in
the drop down list, just select Excel. This will show you all the classes
for Excel. Then if you click on a particular class and one of its members on
the right, information will show up at the bottom of the window.

This is a start. You can probably get more information about each class and
method from googling the net.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top