Open Workbbok In New Window Using VBA

[ganesh25]

Hi,

I have 2 workbooks one macr.xls that contains macro. Now I want to open another workbook using workbbok.open filename:="test.xls".

But I want it to be opened in another new application window.

Manual procedure: Double click on macr.xls to open. Now open new excel application click on file- select open-select test.xls- click on open button.

The same procedure I want to do through macro/VBA

Please help me.

Thanks,
Ganesh.

 

[shg]

    Dim appXl As Excel.Application
 
    Set appXl = New Excel.Application
    appXl.Visible = True
    appXl.Workbooks.Open "C:\myPath\test.xls"

 

[dave3009]

Untested but try

Sub opennewapp()
Dim xlapp As Excel.Application
Set xlapp = CreateObject("Excel.Application")
xlapp.Workbooks.Open "test.xls"
End Sub

 

[ganesh25]

Thanks shg and Dave.
Both codes are working fine. But it is showing me the opened workbook. i.e. test.xls
Actully my macro workbook has a form(frmlogin).
Is that possible to get form on activewindow. Means active frmLoginis on screen.
Thanks,
Ganesh.