Have you dimmed "objexcel" as a module level variable? If not it's local
and goes out of existence when the sub ends.

--
Jim Rech
Excel MVP
"MD" wrote in message
. ..
|
|
| 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
|
|
|
|
|
|