Macro - Object Creation

[system]

120×120 10.4 KB

Update 23-Oct-2009: Another version that can change CLASS names and descriptions can be found here later in this thread. Author: Dwayne Hoffpauir, EDS Corporation Further discussion on this utility should take place in this topic. Author Notes: Option Explicit 'require variables to be declared before being used Dim DesignerApp As Designer.Application Dim Univ As Designer.Universe Dim Wksht As Excel.Worksheet Sub GetInfo() Set DesignerApp = New Designer.Application …

This post might be of use to you.

HTH

---

shamit (BOB member since 2004-07-01)