Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbook in new window using VBA
Hi, I have macro which opens workbbok in new window but I am getting
the same window as activated. But I want original workbbok should be activated. Please help me? Please find below code for the reference. Sub test() Dim MWBK As Workbook Set MWBK = ActiveWorkbook Dim exlApp As Excel.Application Set exlApp = New Excel.Application exlApp.Visible = True exlApp.Workbooks.Open "D:\Documents and Settings\n404591\Desktop \test.xls" MWBK.Activate End Sub Thanks, Ganesh K. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open a workbook using a different window | Excel Discussion (Misc queries) | |||
Detecting if a Window/Workbook is Open | Excel Discussion (Misc queries) | |||
Workbook to Open a new excel Window | Excel Programming | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
deleting second open window in a workbook | Excel Worksheet Functions |