LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically switching between worksheets. dinouk Excel Discussion (Misc queries) 3 December 6th 06 10:08 PM
Short cut for switching between worksheets Paul Gignac Excel Worksheet Functions 2 March 22nd 06 07:37 PM
What is the shortcut for switching between worksheets? DJALik Excel Discussion (Misc queries) 1 September 15th 05 04:55 PM
Switching between worksheets Curious[_3_] Excel Programming 2 November 7th 03 04:56 PM
Switching to different worksheets during a macro Bill Barclift Excel Programming 0 October 9th 03 04:16 AM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"