I am using VBA to control Lotus Notes typically using code similar to the following :
Dim domsession As Object
Set domsession = CreateObject("lotus.notessession")
domsession.Initialize
OR
Dim domsession As New NotesSession
domsession.Initialize
The second script would have a reference to "Lotus Domino Objects"
For some reason both of these scripts now display the following error message:
***********************************
Run-time error '-2147220999 (800401f9)':
Automation error
Error in the DLL
***********************************
The first script displays this error on domsession.Initialize and the second on Set domsession = CreateObject("lotus.notessession")
This error does not occur on every machine only on some. It happens whether the code is in Access or Excel.
Microsoft Jet Service Pack 8 was recently installed on some machines. But, the code still does not work on machines that have'nt had it installed.
Any ideas would be much appreciated.
Thanks
Ian

Automation via VBA Failure (Ian S Curry 20.Dec.05)
. . 