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

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

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