Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing betwen workbooks
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to cells in other workbooks keep changing | Excel Worksheet Functions | |||
Linked workbooks, changing links | Excel Worksheet Functions | |||
Absolute value changing in linked workbooks | Links and Linking in Excel | |||
Changing source on multiple workbooks | Links and Linking in Excel | |||
Clear destination, then copy betwen workbooks | Excel Programming |