getting user defined type not defined when trying to add a reference manually

**dmcgov** · 10-24-2019, 10:42 AM

so here is the code that is failing:

Please Login or Register  to view this content.

on this line:

Please Login or Register  to view this content.

i am trying to add reference to "Microsoft Visual Basic for Applications Extensibility 5.3" programmatically

note that i put the thisworkbook in ThisWorkbook code under Workbook_Newsheet

what am i doing wrong?

**romperstomper** · 10-24-2019, 10:47 AM

Originally Posted by dmcgov

i am trying to add reference to "Microsoft Visual Basic for Applications Extensibility 5.3" programmatically

Why? Just add it to the workbook manually. If you can't do that, late bind the code instead and avoid the reference altogether.

**dmcgov** · 10-24-2019, 10:48 AM

nm, i figured it out, needs to be in a standard module and it works.

getting user defined type not defined when trying to add a reference manually

LinkBack

Thread Tools

Rate This Thread

Display

getting user defined type not defined when trying to add a reference manually

Re: getting user defined type not defined when trying to add a reference manually

Re: getting user defined type not defined when trying to add a reference manually

Thread Information

Users Browsing this Thread

Similar Threads

User-defined type not defined when copying macro from one workbook to another

[SOLVED] Outlook VBA, how to add reference library ["User defined type not defined" ERROR]

compile error User-defined type not defined Set objXL = New Excel.Application

VBA Help Needed: Created an Object but getting an error : user defined type not defined

[SOLVED] User-defined type not defined on Copy to Clipboard Macro

[SOLVED] Compile error: User-defined type not defined

compile error - user defined type not defined

Bookmarks

Bookmarks

Posting Permissions