Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically switching between worksheets. | Excel Discussion (Misc queries) | |||
Short cut for switching between worksheets | Excel Worksheet Functions | |||
What is the shortcut for switching between worksheets? | Excel Discussion (Misc queries) | |||
Switching between worksheets | Excel Programming | |||
Switching to different worksheets during a macro | Excel Programming |