![]() ![]() Private Sub GetObjectInfo(Clss, RowNum As Long)ĭwayne, This is great. If Obj.Name Rng.Cells(RowNum, 4) Then Obj.Name = Rng.Cells(RowNum, 4) Set Obj = Cls.Objects(Rng.Cells(RowNum, 2).Value) Range("Objects").Columns("D:E").Value = Range("Objects").Columns("B:C").Value Range("Objects").Resize( - 1, 5).Name = "Objects" Set Wksht = ThisWorkbook.Worksheets("Objects") Set DesignerApp = New Designer.Application Option Explicit 'require variables to be declared before being used If you choose to copy the code into your own workbook, you will need to create a reference to the Designer Object Library first (Tools, References from the VB Editor). Since I’m the only one that uses the macros, there is very little “bullet-proofing” of any sort, but hopefully you will find it useful.Ī copy of the code is below. I usually send the workbook to my subject matter experts to key the updates. Designer will be left open with the updated universe UNSAVED, to give you a chance to review the updates. You will again be asked to log into Designer and open a universe. Make changes to the columns D,E (in blue). The GetInfo macro “dumps” the current class name, object name, and description in columns A,B,C and repeats the object name and description in columns D,E. You will be asked to log into Designer, and open a universe. ![]() Usage is as follows: Open the Excel workbook, press Alt-F8 and you should see two macros. The complete utility can be downloaded from the link above. It uses Excel as the VBA host and data entry tool, and makes the appropriate calls to the Designer application. This utility provides a high volume method for changing object names and descriptions in a universe, without writing directly to the repository. Update 2: Another version that can change CLASS names and descriptions can be found here later in this thread.Īuthor: Dwayne Hoffpauir, EDS Corporationįurther discussion on this utility should take place in this topic. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |