You don't NEED to have any specific reference. The following will work
without any additional references.
Const vbext_ct_StdModule = 1
Const vbext_ct_ClassModule = 2
Const vbext_ct_MSForm = 3
ThisWorkbook.VBProject.VBComponents.Add vbext_ct_StdModule
However, if you want to use the constants and data and object types,
reference the "Microsoft Visual Basic For Applications. Extensibility 5.3"
library. See
www.cpearson.com/excel/vbe.htm for lots of information and
example code.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)
"greg" wrote in message
...
hello
If I need to create:
VBIDE.VBComponent
What do I need to reference inside of the Excel VBA?
I already have
Excel 11 object library
and
MS Office 11 object library
what else is needed?
thanks