Open In New Instance of Excel

[MikeDBMan]

Is there a way with VBA to force Excel to open a file in a different instance of Excel?

What about in a new instance of Excel? Thanks for any help!

 

[ISY]

Hallo

I hope you understand the request

Sub New_Instance_of_Excel()
    Dim objXL
    Set objXL = CreateObject("Excel.Application")
    objXL.Visible = True
    objXL.Workbooks.Add
End Sub

 

[MikeDBMan]

I see how that works just fine. Now, after I have two instances running, how can I tell Excel to open a file in the other instance. This would happen later after the sub you created has completed. Here is the scenario:
1. I create a second instance of Excel. That Sub ends.
2. Later I wish to open a file in that other instance of Excel.
3. Then I close that file.
4. Then later again I repeat step 2 and 3.

Is this feasible or is it easier/better to just close that 2nd instance of excel and reopen it each time? Thanks.

 

[ISY]

Hallo

You can search for other information about VBscript as:

http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/#OES.htm

You can open a file with:

    Dim objExcel
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    Set objWorkbook = objExcel.Workbooks.Open("C:\Documenti\Test.xls")

 

[sainath]

Hi

Can I use the same defination as in excel.application even if want to open an excel with addin