I did find a solution ⌠got a new computer 8) !!! Kidding of course. I have no idea exactly what was causing the issue. All I know is that it works flawlessly now with Vista / Excel 2007. If you log a tech support case (or whatever they are called now), they can provide you with a âloggingâ utility that may help them debug your issue.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)
Hi Dwayne,
I am getting the famous 430 error as well.
My visual basic references are ticked for âBusiness Objects Designer 11.5 Object Libraryâ. I am using Excel 2003 with BO XIR2 SP4. I donât know what I am doing wrong, If you can help that would be great.
Regards.
Arafiq
arafiq (BOB member since 2006-04-12)
Dwayne,
Great tool! It has saved me 1-2 days of work. I made the changes in object names and their descriptions in 30 minutes (including download of the utility, and reading how to use it).
One suggestion though:
It would be prefect if the utility was capable of renaming class names and class descriptions too 
Thanks again.
Marek Chladny 
(BOB member since 2003-11-27)
What do I do to make this work with XI 3.1 SP2?
Ah no, itâs okay, sorted.
Damocles 
(BOB member since 2006-10-05)
As with most of my utilities, they were developed for totally selfish reasons ⌠making my own job easier! That said, glad you also found it useful!
Iâm sure that is possible. With all the time you saved before, maybe you tinker with it, and share the results with the class :).
Dwayne Hoffpauir (BOB member since 2002-09-19)
OK, done 
The result is attached. I added 1 extra sheet for classes and made few changes and additions to the code.
Universe - Object and Class Names & Descriptions.zip (20.0 KB)
Marek Chladny (BOB member since 2003-11-27)
Hi,
I am working on following version of universe designer & trying to update the description of objects but giving me error as âRuntime error 13 :Type Mismatchâ
univ version-12.1.0.882 [BO XI 3]
Pls give any valuable suggestions,to get rid of this error.
patneel 
(BOB member since 2006-11-02)
BO Gurus,
Anyone pls?.
Itâs giving error for line which is in boldâŚ
Sub MakeChanges()
Dim RowNum As Long
Dim Cls As Designer.Class
Dim Obj As Designer.Object
Dim Rng As Excel.Range
Set DesignerApp = New Designer.Application
DesignerApp.Visible = True
Call DesignerApp.LogonDialog
Set Univ = DesignerApp.Universes.Open
Set Wksht = ThisWorkbook.Worksheets("Objects")
Set Rng = Wksht.Range("Objects")
For RowNum = 1 To Rng.Rows.Count
Set Cls = Univ.Classes.FindClass(Rng.Cells(RowNum, 1).Value)
Set Obj = Cls.Objects(Rng.Cells(RowNum, 2).Value)
If Obj.Name <> Rng.Cells(RowNum, 4) Then Obj.Name = Rng.Cells(RowNum, 4)
[b]Obj.Description = Rng.Cells(RowNum, 5)[/b]
Next RowNum
End Sub
patneel (BOB member since 2006-11-02)
What is the error?
Dwayne Hoffpauir (BOB member since 2002-09-19)
Hi Dwayne,
With the help of this macro, I can extract the details without any error but even when i tried to update the definition of single object using this macro , Its giving me error âRuntime error 13 :Type Mismatchâ
univ version-12.1.0.882 [BO XI 3]
Thanks in Advance
patneel (BOB member since 2006-11-02)
Try stepping through the code to find the specific line that is throwing the error. Then add some âwatchâ values to see where the mismatch is occuring.
Dwayne Hoffpauir (BOB member since 2002-09-19)
Run time error â430ââŚClass does not support automatation or does not support expected interface.
I getting the above message at âSet DesignerApp = New Designer.Application.â I am running on Excel 2003, BOXI R2.
Please help how you people resolve it. ASAP.
And one more, ârequire variables to be declared before being usedââwhat i should declare. I dont know VB. hence pls help.
chaithu1983 (BOB member since 2009-05-19)
Hi, I am keep on trying with the excel sheet for this utility. But I am getting âRun-time error 430. Class does not support automation or does not support expected interface.â
I am using Excel 2003 and I have reference to Tools > Reference > Business Objects Designer 11.5 Object Library and BOXI R2
Please let me know whether i need to make any changes in VB code. (i dont have much knowledge on VB sciprt).
I searched in the forum but didnât find anysolution for this issue.
chaithu1983 (BOB member since 2009-05-19)
Thanks, it works very well and fast on BO XI 3.1 sp2.
I also need to rename the predefinedConditions, So i added 1 extra sheet for them.
I upload this in the uploads sections.
Romain J (BOB member since 2010-07-28)
damocles - what did you do to make it work in XIr3?
olut (BOB member since 2009-08-20)
I had problems and it turned out to be a permissions issue in terms of launching Excel.
Navigate through the start menu to where Excel is located.
Hold Shift.
Right click on the Excel shortcut.
Choose âRun as Administratorâ.
Then open up the Excel file and proceed as normal.
I also have the same problem, but I cannot have Administrator rights on my computer due to company policies.
Does anyone know a work-around?
I have LiveOffice v12.1.0.882 and BOXI Server is on 3.1 FP 3.3 (or FP3)
gratzy (BOB member since 2009-01-26)
works great on my setupâŚWinXP, sp2, w/Excel 2007
Cairmor (BOB member since 2008-06-05)
This looks greatâŚIâm trying to do a similar thing in Crystal to automate the generation of Formula Fields names and formulas. Anyone done anything like that before?
menace (BOB member since 2011-03-08)
Hi Dwayne. I need to update a lot of objects to use the TABLE option so that I can force a join to some tables. It will take me some time to visit each object and then choose TABLE and select the few tables that I want. Is there a way I can amend your utility to do this? I had a quick browse in the object model but I couldnât see anything obvious (that worked anyway!). Thanks in advance.
Grantie (BOB member since 2004-07-01)