You need to add a reference to "Microsoft Visual Basic For
Applications Extensibility" (in the VBA window, select
Tools/References and set the check box for this).

Andrew



Jim Jackson 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?

--
Best wishes,

Jim