PC Review Forums Newsgroups Microsoft Access Microsoft Access VBA Modules referense to sheet in opened workbook

Reply

referense to sheet in opened workbook

 
Thread Tools Rate Thread
Old 16-04-2004, 02:06 AM   #1
AlexD
Guest
 
Posts: n/a
Default referense to sheet in opened workbook


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

  Reply With Quote
Reply



Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off