Automation Classes / Methods, overview or list
 

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

Automation Classes / Methods, overview or list
 

Please i need y too, if someone knows, please help us!!

thanks.

"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

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