system
June 23, 2008, 3:49pm
#1
I am using a macro to document a universe, in MS Excel. I am doing some changes in the excel file. Is there a way to write it back to the universe using macros?
trigger (BOB member since 2008-06-05)
system
June 23, 2008, 3:57pm
#2
Sure, in fact you can download some examples… first, this one extracts information from a universe:
Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url]
Notes: The attached utility uses Excel and the Designer SDK to document a universe. Usage is rather straightforward. Click the "Document a Universe" button on the Control Sheet, log in, and select the specific universe. Information will be recorded on separate worksheets for:[list:5d8cd1056f]Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions[/list:u:5d8cd10…
This one can be used to publish help text (object descriptions) back to the universe:
Update 23-Oct-2009: Another version that can change CLASS names and descriptions can be found [url=http://www.forumtopics.com/busobj/viewtopic.php?p=666079#666079]here[/url] later in this thread.
Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS Corporation[/url]
Further discussion on this utility should take place in [url=http://www.forumtopics.com/busobj/viewtopic.php?t=20992]this topic[/url].
Author Notes:
[quote:d8ce665e88]This utili…
Dave Rathbun (BOB member since 2002-06-06)
(BOB member since 2002-06-06)