| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open closes other workbooks
When I execute the Workbooks.Open method - an existing workbook in the Excel
window vanishes. Does anyone know how to prevent this? Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Open closes other workbooks
Hi Steve,
I'm assuming that you mean the existing workbook isn't in the foreground and the new workbook that is opened comes to the front, in this case try... ThisWorkbook.Activate after you use the open method this should reactivate the workbook the code was called from. Regards, Rocky McKinley "S. Daum" wrote in message ... When I execute the Workbooks.Open method - an existing workbook in the Excel window vanishes. Does anyone know how to prevent this? Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming | |||
Hybrid Mode
