View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How to open a new instance of EXCEL and .xls file

Sub NewExcel()
Dim oXL As Object
Dim oWB As Object

Set oXL = CreateObject("Excel.Application")
oXL.Visible = True
Set oWB = oXL.Workbooks.Open("C:\myBook.xls")
'...
Set oWB = Nothing
oXL.Quit
Set oXL = Nothing
End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Launchnet" <u20911@uwe wrote in message news:73c27ac1692ba@uwe...
I need a macro that will open a second Excel program and open a specific
file
name "name.xls" at the same time.

I could also use a macro that would only open a second Excel program with
an
empty workbook.

Thanks in advance for your help.

Matt @ Launchnet

--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping