View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Brown Daniel Brown is offline
external usenet poster
 
Posts: 2
Default Switching between Worksheets

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.