View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Jackson Jim Jackson is offline
external usenet poster
 
Posts: 324
Default Dim VBComp As VBIDE.VBComponent

After further investigation, I found that a later line's absence caused the
jibberish. Now I am having trouble getting the routine to pass to the next
file in the directory. What seemed to work earlier now gets an error message
"Invalid procedure call or argument". I am using these two lines

w = Dir("H:\*.xls") ' sets the path
'check for modules and export/import - close the first workbook
w = Dir() ' Is supposed to cause the choosing of the next file in the folder


--
Best wishes,

Jim


"David" wrote:

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?