Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am running a VBA script in Excel, and need help with displaying the workbook I select if it is in an Internet Explorer window. workbooks().activate and windows.activate() doesn't quite work. To get a list of workbooks I do: For Each wb In Workbooks If wb.Name < ThisWorkbook.Name Then Me.ComboFilename.AddItem wb.Name End If Next wb If I do: Workbooks(ComboFilename.Text).Activate Then if the workbook is running in this copy of Excel, it will be displayed. But, if the workbook was opened in IE then it activates, but the window does not display. How do I get the IE window to display? Joel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Activate Workbook | Excel Discussion (Misc queries) | |||
Activate Different workbook? | Excel Programming | |||
Display Excel file in Internet - an interesting question | Excel Programming | |||
Activate Other Workbook | Excel Programming | |||
Activate Workbook | Excel Programming |