Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How could I open another spreadsheet in the same workbook
if the workbook has been already opened? I'm doing it from MS Access. If logWorkbookIsOpened = False Then 'it's working good Set xlBook = xlApp.Workbooks.Open(strWorkbookName) Set xlSheet = xlBook.Worksheets(strWorksheetName) xlSheet.Activate xlApp.Visible = True Else 'here is a mistake #0 Set xlSheet = Workbooks(strWorkbookName).Worksheets (strWorksheetName) xlSheet.Activate xlApp.Visible = True End If Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to print a workbook but worksheets have diff print areas | Excel Discussion (Misc queries) | |||
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
Count If 2 Diff Values Appear on Several Worksheets w/in Workbook | Excel Worksheet Functions | |||
Slow opening Excel Workbook with over 50 Worksheets | Excel Discussion (Misc queries) | |||
Is it possible to require that a KEY NUMBER be imputed in a workbook 1 before workbook 2 can be opened? | Excel Programming |