Open Excel
This code does not seem to work for me.
Sub NewExcelWindow()
Set objexcel = New Excel.Application
objexcel.Visible = True
End Sub
A) As soon as the sub ends, the new excel intance closes also.
B) It does not open a workbook inside the new excel intance.
Just like Application.ActivateMicrosoftApp xlMicrosoftWord but for a new
EXCEL intance. I'd like to open a new workbook on a new intance of EXCEL.
PS Why doesn't Application.ActivateMicrosoftApp xlMicrosoftEXCEL work??? It
works for Access, word etc...
Regards,
Michel
|