Document a universe using Excel and the Designer SDK

Hi Dwayne Hoffpauir, Thanks for the spreadsheet. When I try to execute the attached spreadsheet, I am getting the error "Run-Time Error '91' " Cannot Get Mother CLass Is there any remedy for the same.
Hmmm ... that error happens when trying to find the .Rootclass property for a class that is already at the top level. The code is supposed to trap that error and be able to continue. Any chance that you've tweaked the code, and possibly disabled the error handling? Does it happen if you download a clean copy? Be sure you are using the correct version of the utility as well. If that doesn't fix it, I may have to ask you to send me a copy of the universe causing the problem.
Hi Dwayne, I have downloaded a clean copy and try to execute the same. I am still having the same issue.
Kaustubh: Are you using the correct Library of BO version. (I mean in the Tools-->Reference) ?
And I get the error: "Compile error: Can't find project or Library" with this part of code highlighted: [code:1:9a0b22420a]Sub ListTables(Tbls As Designer.Tables)[/code:1:9a0b22420a] Any Ideas please: Thanks, brawn
[quote:f482813713="brawnbrawn"]And I get the error: "Compile error: Can't find project or Library" with this part of code highlighted: [code:1:f482813713]Sub ListTables(Tbls As Designer.Tables)[/code:1:f482813713] Any Ideas please: Thanks, brawn[/quote:f482813713] Do you see this function 'ListTables' exists in the code.. when you go down in script window ?
Yes, I saw that sub() has been used couple of times in Dwayne's code. I get this error when i try to run all the version(Xir2, 6.5 and 5). . Is anything wrong on my PC? or is it for everybody.Any ideas dwayne Thanks, Brawn
Try going into the vba editor of Excel, then under 'tools..references' ,make sure you have checked 'Business Objects Designer Library'. Then try running it. I hope this helps.
Hi Dwayne, Do you also have a similar macro which can be used to document a report. Thanks. Manish
[quote:1c954b5576="manishdarak"]Do you also have a similar macro which can be used to document a report.[/quote:1c954b5576] For universe objects, try this ... [url=http://www.forumtopics.com/busobj/viewtopic.php?t=60568]List objects used in a series of reports[/url] To document more about a report, look here ... http://lyontechnologies.com/free_stuff.htm ... for the documentation add-in.
Hi, When i tried to Document a universe. i am getting the following error Failure in ListObjects() VBAProject- -2147417851: Automation error The server threw an exception. universe version : XIR2 Can any one please help me in this ?
[quote:015b013a3a="Ramprasad"]Failure in ListObjects() VBAProject- -2147417851: Automation error The server threw an exception.[/quote:015b013a3a] Any chance that the description on an object is extremely long ... like more than 1,024 characters? Try changing the line of code that says this...[code:1:015b013a3a]Rng(RowNum, 4) = Obj.Description[/code:1:015b013a3a] ... to this[code:1:015b013a3a]Rng(RowNum, 4) = Left(Obj.Description, 1024)[/code:1:015b013a3a]
what do the following mean in the documenting excel in Objects tab: Security Access Level(0)/Can be used Result(True/False)/Can be used Condition(True/False)/Can be used sort(True/False)/Show(True/False) Thanks Shruti
All of those are various properties of the object as set up in the universe. If you open a universe and look at the properties tabs (there are several) you should be able to figure it out. :)
Hi Dwayne Hoffpauir, Thanks for your reply. I changed the Macro code,still i am getting the same error. Thanks, Ram
[quote:c9130aee53="Ramprasad"]I changed the Macro code,still i am getting the same error.[/quote:c9130aee53] I can only suggest that you step through the code, and report back exactly which object, property, and value is causing the problem. I may be able to offer a solution with that information.
Dwayne, I used the download for 6.5 and it worked great for the first universe I tried. But when I run it against a much larger universe, it gives me a "Failure in ListObjects(): "VBAProject 7 - out of memory" error. Do you know of a way to get around this? Does it mean physical memory on my PC (it is rather old). Thank you so much, Linda
Hi I get the error: "Compile error: Can't find project or Library" with this part of code highlighted: For this how can i include the business objects library ? Adv. Thanks Raghu
[quote:5b66af9373="lcaron"]Dwayne, I used the download for 6.5 and it worked great for the first universe I tried. But when I run it against a much larger universe, it gives me a "Failure in ListObjects(): "VBAProject 7 - out of memory" error. Do you know of a way to get around this? Does it mean physical memory on my PC (it is rather old). Thank you so much, Linda[/quote:5b66af9373] Might the discussion [url=http://www.forumtopics.com/busobj/viewtopic.php?p=485896#485896]here[/url] explain it?
[quote:6148ca2b80="rpothineni"]"Compile error: Can't find project or Library" with this part of code highlighted: For this how can i include the business objects library ? [/quote:6148ca2b80] 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?