Solved

Automating Internet Explorer

Posted on 1999-01-13
6
256 Views
Last Modified: 2008-01-09
My application needs to get the URL of the page currently displayed in IE and respond accordingly. Here's part of the code I'm using:
...
    On Error GoTo StartExplorer
    Set ie = GetObject(, "InternetExplorer.Application")
    Exit Function
StartExplorer:
      If Err.Number = 429 Then _
      Set ie = CreateObject("InternetExplorer.Application")
...

According to the documentation, the GetObject function is supposed to start a new instance of IE only if IE is not already running. My problem is that it always opens a new instance of IE.

Am I using GetObject correctly? Or is there any other way to get the current URL (and go to a new URL) in the currently active IE window? I do not want to embed the browser within my app. (I am using DDE with Netscape, and it works fine.)

Thanks. Jim
0
Comment
Question by:biffman9
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1455946
Here are the DDE topics:
IExplore|WWW_OpenUrl

0
 

Author Comment

by:biffman9
ID: 1455947
I'm willing to give DDE with IE a try, but I'll need more than just the open URL call. I'll also need at least an Activate and a getURL. Pointing me to where IE DDE is documented will do. Thanks.
0
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1455948
Goto support.microsoft.com and search for Q160957
This article describes DDE in IE.

BTW:
The other topics you requested are WWW_GetWindowInfo and WWW_Activate
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:biffman9
ID: 1455949
Good answer. As it turns out, the IE DDE is the same as Netscape, making my code much more elegant. Thanks.

I'm not sure how to re-grade your answer as acceptable and good.


0
 
LVL 13

Accepted Solution

by:
Mirkwood earned 150 total points
ID: 1455950
I'll just answer it again.
0
 

Author Comment

by:biffman9
ID: 1455951
I've fount that Internet Explorer's response to DDE is a bit unpredictable (not a surprise, I guess, given its problems in other areas). If more than one IE window is open, only the first-opened IE window will respond to DDE; but if you close that first window, the other IE windows will respond as they should.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question