Hi,
I am trying to understand OLE with BaaN IV (some examples are mpsole.xls, findbug.xls, ecc.). I can run mpsole.xls, but I can' t run GetBaanUsers in Baan.xls. The error is "Run Time error: 462. The remote computer doesn't exist or it is not avilable". The reason seems to be the return value of Baan.Obj.ParseExecFunction(which is set to zero), but I suppose the connection to BaaN was never estabilished (the connection is estabilished through "Set BaanObj = CreateObject(Baan4.Application)").
I set a default BW and during the login the hostname and the user are rigth. There aren't any other open BW. Why the error 426 ?

If I click then Baan button in the MPS worksheet, the connection to BaaN is estabilished through the routine StartProcess and this works. Can I use StartProcess instead of CreatObject?

Another question: I'd like to download from Baan to Execl a table (for example ttaad200, Users), then I'd like to modify something (for example ttaad200.name) and then send all records to Bann.
The downlaod is something like GetBaanUsers, but this would have the same functionality of the worksheet InputSpec in mpsole.xls. Is it possible? And if I would download only users which satisfy some conditions (for example all users whose name begins for "a", then all users whose user type is super user) how can I do ?

I hope someone could help me.
Thanks.

After logging in do you only get the option dialog box? Is ttstpoledaem running? Just some questions that may help someone else recognize a solution.

I have had problems like this before. It could be a combination of any of these - baan client, porting set, tools objects. All of those need to be sync'ed up. I usually do not like to do this, but you may want to contact the support center.

Mark