Home > IT Answers > Development > CreateObject function fails – Cannot Create Automation Object
Simonm
0 pts.
 CreateObject function fails – Cannot Create Automation Object
Development, LotusScript
I am running this piece of code: 'CreateObject("Excel.Application")' The context of the code is correct (i.e. its in the right place), as is the syntax (spelling, variable assigment etc.) I receive the error "Cannot Create Automation Object" (Error code 208) when the code is run in an agent on a Domino 6 server. Excel IS installed correctly on the server, registry settings are correct, and the agent is set to run under runtime security level 3. I have searched numerous resources and tried numerous solutions, none of which have helped. Any and all advice gratefully received!

Software/Hardware used:
ASKED: February 14, 2005  9:44 AM
UPDATED: February 16, 2005  4:01 AM
RELATED QUESTIONS
Answer Wiki:
As a test install the Designer on the server and see if you can see the excel objects in the OLE Classes. If you do not see them then you do not have Excel installed and registerd correctly so that Domino can see it. Some installations of Excel need to have the the line read something like CreateObject("Excel.Application.11")' This is for Excel 2003. Good luck. These can be a pain to troubleshoot.
Last Wiki Answer Submitted:  February 15, 2005  1:59 am  by  Madkahuna   0 pts.
All Answer Wiki Contributors:  Madkahuna   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

YOU SHOULD ADD THE MICROSOFT EXCEL FROM ADD NEW COMPONETS
IN VB.

OK. THANKS FOR ASKING.

DATABASESQL2000
 0 pts.
 

Just an FYI. In Lotus Notes you do not have the add component option as you do in VB or VBA. When you make a call to create tha automation object it automatically adds the component and runs it. This is one of the nice things about using LotusSctipt versus VB/VBA. If the correct application is installed all you have to do is call the create automation object and you are up and running.

You can pretty much copy and paste VBA code into LotusScript and run it with very feew modifications. For those VB/VBA programmers that would like to learn a little bit more about this check out the IBM RedBook called:

IBM Redbooks | COM Together – with Domino
http://www.redbooks.ibm.com/abstracts/sg245670.html?Open

Hope that helps some of you out there. It is quite short only 151 pages.

Madkahuna
 0 pts.