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/