Thread: Open Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
 
Posts: 26
Default 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