Thread: vbide
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default vbide

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