Lotus Notes Automation with VBA: activex component can't create object

Posted on 2005-04-07
Last Modified: 2009-07-29
Hello Experts,

I have a project in Access XP which uses the lotus notes automation classes (notes32.tlb) to perform various calendar tasks.  I have everything working perfectly on seven machines (all of them xp sp2, 6 with office 2k3 and LN 6.5 and one with office xp and LN 6.0.3) but as luck would have it, my boss' machine keeps giving me runtime error 429 "Activex component can't create object".  The machine is set up identical to my dev machine (which is the one with office xp and LN 6.0.3) so it is not the software version, I have already tried replacing notes32.tlb with a known working copy from my dev machine and I am all out of ideas.  The functions I am using are:

The error comes on this line:

Set ns = CreateObject("Lotus.NotesSession")

Thank you in advance.

Question by:jkorz
    LVL 14

    Accepted Solution

    Just a thought

    could you try this in your boss machine:

    regsvr32 c:\notes\nlsxbe.dll (the path of the notes).

    - Partha
    LVL 8

    Author Comment

    what is nlsxbe.dll?

    as far as I know, automation only uses notes32.tlb...

    i'll give it a try though
    LVL 14

    Expert Comment

    LVL 8

    Author Comment

    that did it, thanks a bunch
    LVL 8

    Author Comment

    haha, EE has made me so lazy... It was the first result when I googled it

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now