LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activate Workbook Dolphinv4 Excel Discussion (Misc queries) 2 October 22nd 05 01:45 PM
Activate Different workbook? John Excel Programming 6 August 1st 05 05:51 PM
Display Excel file in Internet - an interesting question Charles Excel Programming 0 August 16th 04 01:39 AM
Activate Other Workbook pauluk[_37_] Excel Programming 16 April 20th 04 07:02 PM
Activate Workbook Molly Johnson Excel Programming 1 February 10th 04 05:09 PM


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"