Hi Team,

I want to open BAAN using VBA and fetch details, Used below code
"Set BaanObj = CreateObject("Baan.Application.Name_of_.bwc_file")"

But i am getting error message
ActiveX Component Cant Create Object.
Kindly suggest Reference Library need to be added for controlling BAAN

Moved to this forum. This forum will probably have a few examples.

The first thing I would ask is do you have the baan client installed on the desktop you are using? On my system the last tab in configuring the client is automation - this is were I would define the name to use in that create object. I never really used this and it used to cause issues if I was already logged into the baan client and tried to run some of the excel examples I had.

Hi Team,

I want to open BAAN using VBA and fetch details, Used below code
"Set BaanObj = CreateObject("Baan.Application.Name_of_.bwc_file")"

But i am getting error message
ActiveX Component Cant Create Object.
Kindly suggest Reference Library need to be added for controlling BAAN

To avoid this error, add the OLE Automation Baan4 1.x Type Library.
6631

*Take note of the path... if the bw.tlb file is missing, you'll need to locate your Baan4 installer files and copy it out of the Data1.Cab archive into the directory listed.
6632