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
Bookmarks