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