Open text file to specific workbook

Hi there, I have the following code that I have recorded that basically opens a text file called UserTrace, applies a few few filters, copies to another sheet, deletes the original sheet and then opens a new text file called ORDPRODS.

Please Login or Register  to view this content.

The problem is when the 2nd text file opens it in opens in a new workbook called "ORDPRODS". Where I want the data to be is in sheet2 of "UserTrace" so I can easily perform various VLOOKUP's (I also have to do the same with another text file later). Is there anything I can do to

Please Login or Register  to view this content.

to achieve this.
Many thanks in advance for any suggestions

Assuming that the code presents the data in the format you want, albeit, in a sheet in a new workbook, I'd be inclined to bow to the inevitable ... take the ActiveSheet in the ActiveWorkbook and copy it to ThisWorkbook, that is the workbook with the code in it.

Regards

TM, thanks for your reply. I was hoping to avoid a few steps and sending the code from one workbook to another (Wishful thinking!!!!!). Ah well back to putting in more code.............
Solved