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.NotesS ession")
Thank you in advance.
-Jkorz
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.NotesS
Thank you in advance.
-Jkorz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that did it, thanks a bunch
ASKER
haha, EE has made me so lazy... It was the first result when I googled it
ASKER
as far as I know, automation only uses notes32.tlb...
i'll give it a try though