PC Review
Forums
Newsgroups
Microsoft Access
Microsoft Access VBA Modules
referense to sheet in opened workbook
Forums
Newsgroups
Microsoft Access
Microsoft Access VBA Modules
referense to sheet in opened workbook
![]() |
referense to sheet in opened workbook |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

