The OpenText method is only available with the Workbooks object. When it's called, it creates a new workbook with a new worksheet and assigns all text data to this worksheet. OpenText cannot be used to open a second file into the same workbook object, let alone the same worksheet.
The only way to do this is to parse out the data and write it to the same worksheet.
Alternatively, you can create a single workbook object and add a new worksheet for each file you want to import. Via kix, parse the data and add it to each worksheet. When finished you can call the MergeWorkbook object.
Here's another thought: Programmatically copy the contents of each file to the clipboard and paste the contents into a given cell. If this is one column of data, for example, paste the first file into A1, the second into B1, etc. That way, you could have all of your data in one worksheet from the start.
_________________________
Stevie
