You do have Designer installed on the machine, correct? In the VB Editor, go to Tools, References and be sure the proper library is selected. If that doesn’t explain it, might you have more than one version of Designer installed on the machine?
I have some troubles to run this document generator.
My configuration is the following:
Business Objects: 6.1
System: Windows 2000
I am using the excel version 6.5 and i got this error after clicking the push button “Document a universe”, as my VBA knowledge is not so bad, i have track the debug, and it appears that it’s just blocking at the first interesting line of the code: Set DesApp = New Designer.Application
This is the error I get:
and the references I am using in my VBA:
I have only one Application Designer 6.1 installed
I have checked the MDAC (2.7 Refresh) etc… and i have looked into the web, but I can’t find the solution…
Thanks for your advise
Ps: It gives me the same error with the word document generator… and the compilation of the vba runs correctly
V6.1 was one of the buggiest releases ever, so this may just be another “symptom” of that release. That said, there is no reason to have the BusinessObjects 6.0 Object Library selected. Only the Designer object library is used by this utility. Since the original was done with 6.5, you might try de-selecting even the Designer library (then maybe save, close, re-open Excel), then re-selecting the Designer library.
Thanks for your quick reply. I have tried your way, but still getting these errors…
And thanks for the info around 6.1, as this version has been implemented by our payroll provider… I understand why they want to upgrade their clients to XI in the near future
I am also having the same problem with the “430 Class does not support …” error. I am on XI r2 sp3. I can run it on some of our PC’s but not on all. We are all on the same version of XIr2 but also use Crystal and Xcelcious. I opend a case with BO tech support on this yesterday and they sent me a program (Modules.exe) to show what DLLs are loaded by applications to see if there are any differences between the machines where it will work and those where it won’t. It may have something to do with the order that our products were installed. I won’t get a chance to check it out until next week but I’ll post if I find a solution.
Has anybody else had any luck with solving this problem?
I have resolved my “430 Class does not support …” error. I had also been having problems with getting all the way through the Import Wizard and was instructerd (by Bus Obj tech supprt) to uninstall all my Business Objects, Crystal, and Xcelcious reports desktop applications and re-install them in a specific order (Crystal reports, Then Bus Obj client tools, then Xcelcious). Apparently there my be conflicting DLLs. This fix for the Import wizard also fixed my ‘430’ error.
Mike, those should be detailed in the “Object Browser” of the Designer SDK. While you have your Excel file open, go into the macro code and click the Object Browser menu option. I think that’s the correct text. From there you can search for the various cardinality or other values and see how they are assigned.
It’s also in the SDK documentation. Take a look at the object model diagram (OMD), because the “enumerations” are included on the high-level diagram pages.
Open the workbook, then press Alt-F11 (opens the VB editor). Go to Tools, References, and look for a Business Objects Designer library to be selected. What does it say (what version, etc.)? Go to Debug, Compile VBA project. Any error messages?