View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 195
Default Dim VBComp As VBIDE.VBComponent

I've avoided having to add reference with:
Dim VBComp As Object

--
David?B?SmltIEphY2tzb24=?= wrote

I am getting the "user-defined type not defined" error message on this
line:

Dim VBComp As VBIDE.VBComponent

I thought I had worked around it but, when the modules were imported,
they only contained jibberish so obviously I need this line.

Can anyone tell me what is missing?