Automation Classes / Methods, overview or list
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.
"Ole Schjoeth" wrote:
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
|