easy one!

M

MD

I have a blank,

What is the code to start a new EXCEL application. Independant from the
first one that is opned ?

thx

Michel
 
R

ross

Hi,

Try this

Public Sub NewExcelWindow()
Set objexcel = New Excel.Application
objexcel.Visible = True
End Sub

Good Luck
ross
 
M

MD

Thx Ross but I guess I wasn't clear in my request.

I want to open the EXCEL application BUT with a new workbook in it. If I
use your code, as soon as the sub ends, the application closes also. I wish
for the worbook to remain open. In other words, have 2 independant sessons
of EXCEL running.

Michel
 
R

ross

Michel,

sorry.

add this in the declarations section of the module

Global objexcel as Excel.Application

also update other code to

Public Sub NewExcelWindow()
Set objexcel = New Excel.Application
objexcel.Visible = True
objexcel.Workbooks.Add

End Sub

which will open a new book aswell


good Luck
ross
 
Top