Changing betwen workbooks

J

Jordi

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
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Adding custom menus to existing excel application 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Excel crashes and restarts when accessing newly created worksheet 2
Checking if a workbook is open 7
Opening a list of Excel files and run a macro in each 17
Unwanted workbooks on startup 2
populate a combobox based on unique values in another workbook 16

Top