olabas
11th June 2002, 17:11
I am trying to get a Connection via OLE in a VBA-Script using:
Set baan = CreateObject("Baan4.Application")
That works well if no other instance of bw.exe is running on the client at the same time.
If a instance of bw.exe is running a runtime error occurs and
the bw messeges window shows the following message:
Error in CreateInstance(IUnknown*, REFID, LPVOID*). SendOleEvent timed out.
Does anybody has an idea why this happens and how to fix it?
Darren Phillips
11th June 2002, 17:31
Try calling a specific BW config file like
Set baan = CreateObject("Baan4.Application.nameofBWconfigfile")
mark_h
11th June 2002, 19:48
Hello Darren!
This post and this post (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=5350&perpage=15&display=&pagenumber=2) mention the Set baan = CreateObject("Baan4.Application.nameofBWconfigfile") format. My question is -Does this require a certain client?
On my system I make sure I run my ole type reports one after the other just to avoid the problem olabas mentioned. The format you and the other poster mentioned may solve this problem, but since I am on an older client b40c.044 and gunther mentioned a b40c.063(I think) client. Would the newer client provide this functionality? I guess registry entries need to be created before the above format would work and I am thinking a new client would take care of that.
Thanks
Mark
Darren Phillips
12th June 2002, 00:32
knowledge base case no 112133 explains the changes made to how the ole works in the client and new regisry changes, I think it appeared in version b40c.060 or b40c.061.
olabas
14th June 2002, 12:46
Hello everybody
The case no 112133 fixed my problem. The mistake was that ottstpoledaemon was not running. Now it works well.
To mark_h:
My idea was to give users some helpfull tools in excel. Normaly they will work with both (excel and baan) at the same time. That was just impossible before.
Thanks to all