Once you copy the data, you can close the sheet.

--
Regards,
Tom Ogilvy

Daniel Brown wrote in message
...
Say I open a text file with the Workbooks.OpenText function into a
worksheet called textImport. Then in that same workbook I have a sheet
called sheet1. Can I close the textImport sheet? Or do I just have to keep
switching off between worksheets? How do I do that? The reason I ask is
because I have a template on sheet 1 and I only need the text file import to
read data from the text file into arrays then I need to take the information
from the arrays and put it into the template sheet therefore I don't need
the textImport sheet. Any advise or help will be appreciated.