Link to home
Start Free TrialLog in
Avatar of jkorz
jkorz

asked on

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

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:

https://www.experts-exchange.com/questions/21357526/Check-free-time-on-LotusNotes-calendar-with-VBA.html

https://www.experts-exchange.com/questions/21361987/Create-Lotus-Notes-Appointment-From-VB.html

The error comes on this line:

Set ns = CreateObject("Lotus.NotesSession")

Thank you in advance.

-Jkorz
ASKER CERTIFIED SOLUTION
Avatar of p_partha
p_partha

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jkorz
jkorz

ASKER

what is nlsxbe.dll?

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

i'll give it a try though
Avatar of jkorz

ASKER

that did it, thanks a bunch
Avatar of jkorz

ASKER

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