CreateObject function fails – Cannot Create Automation Object

pts.
Tags:
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!

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DATABASESQL2000
    YOU SHOULD ADD THE MICROSOFT EXCEL FROM ADD NEW COMPONETS IN VB. OK. THANKS FOR ASKING.
    0 pointsBadges:
    report
  • Madkahuna
    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.
    15 pointsBadges:
    report
  • jayeshg
    CreateObject(“Excel.Application.11″)’ This is for Excel 2003

    For Excel 2010 ?
    10 pointsBadges:
    report
  • TomLiotta

    For Excel 2010 ?

    Note that Excel 2010 was not available until April 2010. The question is from 2005.

    Tom

    125,585 pointsBadges:
    report
  • shivasanjay
    hope you have used in this format
    dim x as variant

     set x=createobject("Excel.Application")


    here x is variant type, this declaration is also needed
    2,660 pointsBadges:
    report
  • TomLiotta

    The context of the code is correct (i.e. its in the right place),

    You need to show us.

    as is the syntax (spelling, variable assigment etc.)

    You need to show us.

    Excel IS installed correctly on the server,

    You need to show us.

    registry settings are correct,

    You need to show us.

    You tell us everything is correct and an error appears. As likely as anything else might be, something is not correct and you miss seeing it. We can't tell without seeing what you're working with. We need to see the work.

    Tom

    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following