View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Changing betwen workbooks

A separate instance of excel is no different than any other application. If
you want to work with that instance, you would have to use GetObject, but I
don't think there is a way you can guarantee that it won't grab the current
instance.

You can use the API to find the separate windows, but I don't know how you
would convert that to a com interface so you could control that application.

--
Regards,
Tom Ogilvy

Jordi wrote in message
...
If I have a Workbook with code opened, and an external application creates
and open a new workbook this second workbook is opened in a new Excel
Enviroment and I coudn't access to it form the first one.

I have to windows opened, but the code only returns one.

Public Function funfinestres()
Dim wdw As Window
For Each wdw In Application.Windows
MsgBox wdw.Caption
Next
End Function