CODEWITHSUNDEEP
vbaexcel
czchlong
czchlong

Reputation: 2574

How do I find out more information about an unknown data type in Visual Basic for Applications?

I was provided an Excel document by a third party with macros and I am supposed to extend their functionality.

As I am reviewing the third party code, I came across some weird data types:

IUtlPropertySet2
CStandardPropertySet2

They are being used like so:

Dim myDataType as IUtlPropertySet2
...
Set myDataType = new CStandardPropertySet2

I have searched all of their files for these data types but could not find them anywhere.

Could someone shed some light on what these data types could be?

Upvotes: 0

Views: 887

Answers (1)

Holistic Developer
Holistic Developer

Reputation: 2526

Use the VBA Object Browser to find out what they are.

  1. Open your Excel spreadsheet.
  2. Press Alt+F11 to open the VBA environment.
  3. Press F2 to open the Object Browser window.
  4. Type the name of the data type into the search box and click the binoculars icon.
  5. Use the search results to find out more information.

Upvotes: 2

Related Questions