Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error on "dim x as VBComponent"?
I get a Compile Error ("User-defined type not defined") whenever I
attempt to dim anything as "VBProject" or "VBComponent", even though both objects are documented by Excel help. Am I missing something simple? I'm using Excel 2003, Office Pro Edition. Same problem on a different PC running Excel 97. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error on "dim x as VBComponent"?
Pat,
You need to set a reference to the extensibility library. In the VBA Editor, go to the Tools menu, choose References, and then scroll down to and check "Microsoft Visual Basic For Applications Extensibility Library". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "PatFinegan " wrote in message ... I get a Compile Error ("User-defined type not defined") whenever I attempt to dim anything as "VBProject" or "VBComponent", even though both objects are documented by Excel help. Am I missing something simple? I'm using Excel 2003, Office Pro Edition. Same problem on a different PC running Excel 97. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile Error on "dim x as VBComponent"?
I knew it had to be simple. Of course, I then discovered that I had to
change my security settings (Excel 2003 apparently differs from Excel 97 on "Trested Publishers"). --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get a VB "Compile error in hidden module: DistMon" at start | Excel Discussion (Misc queries) | |||
How correct (or remove) "Compile error in hidden module: DistMon" | Excel Discussion (Misc queries) | |||
"compile error in hidden module": DISTMOD -- ideas to fix it?? | Excel Discussion (Misc queries) | |||
"compile error in hidden module" | Excel Discussion (Misc queries) | |||
Compile Error in Excel 2004 when Inputbox contains "VBCRLF" | Excel Discussion (Misc queries) |