vbide

[greg]

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

 

[Chip Pearson]

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)