referense to sheet in opened workbook

AlexD

Guest

Posts: n/a

16th Apr 2004

If some spreadsheet and workbook are already opened like
this:

Set xlBook = xlApp.Workbooks.Open(“BookName”)
Set xlSheet = xlBook.Worksheets(“theFirstSheetName”)
xlSheet.Activate
xlApp.Visible = True

How could I activate another theSecondSheetName
spreadsheet to be able to see it from the same workbook?

Thanks

« Programming Help...really stuck..Audit Logs | VBA tie to copy/paste »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Save each sheet of multi-sheet workbook as a single-sheet workbook	CTB	Microsoft Excel Programming	3	17th May 2011 09:40 AM
Selecting a specific sheet by codename in an opened workbook (XL03	ker_01	Microsoft Excel Programming	2	10th Feb 2010 05:40 PM
Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is opened	Ronald Dodge	Microsoft Excel Programming	13	18th May 2007 03:24 PM
Sheets select method fails when workbook is opened by another workbook	Mike	Microsoft Excel Programming	2	8th Jun 2004 05:17 AM
How to read sheet of currently opened workbook	Jedi	Microsoft Excel Programming	1	11th Sep 2003 12:00 PM