Activate and Display a Workbook in Internet Explrorer
 

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