VBA designer bo

Hello,
I am trying to access designer (bo 6.5) through vba.
I get error Run-time error ‘430’ Class does not support automation or does not support expected interface at line
Set DesApp = New Designer.Application
when I do the same with business object
set abc = New busobj.Application it works fine.

Any suggestion

Also another question is - do i need to have bo client on the machine from where I want to run my excel macro.
Is it possible that I can copy the lib (designer and business object) from server and reference them without installing the client.


bhardwaj_rajesh (BOB member since 2009-07-17)

Hi,
Check which libraries are used in the references of the VBA project (Tools → References). Do you reference BO Designer 6.5 Object Library?


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Solution is here.


Dennis W. Disney :us: (BOB member since 2003-09-17)