Opposite to Shell command

[Accessdabbler]

I am using the SHELL command to launch an Internet Explorer window.

How to I then issue a command to CLOSE that window?

If I'm not being clear, here's what I am doing:

User pushes a button on a form. A webpage opens up and some data is downloaded from a website. I then need the webpage to close. User does not need to see the webpage.

The download is working great but I am getting a blank webpage sitting there when I push the button. Using code like:

Application.quit closes MSAccess instead of IE!!

 

[nice95gle]

There is no Property of Shell to close a app/window. You will have to close that app using an API function.

So to open and close an IE Window follow the example I posted below.

You have to set a Reference to "MICROSOFT INTERNET CONTROLS"

Dim myWindow As InternetExplorer

Set myWindow = New InternetExplorer
With myWindow
    .Visible = True
    .Navigate ("[URL unfurl="true"]www.microsoft.com")[/URL]

'YOUR CODE FOR THE DOWNLOAD GOES HERE

    .Quit
End With

If the user don't need to see the page set
.Visible = False

 

[Accessdabbler]

Will this work with Access97? I tried it but I get an error that "Internet Explorer" is not defined.

 

[nice95gle]

which line does it fail on?

 

[Accessdabbler]

The first line. It doesn't recognize InternetExplorer as a variable type.

 

[nice95gle]

You have to set a Reference to "MICROSOFT INTERNET CONTROLS"

in any module window
goto -> Tools -> References -> and click on "MICROSOFT INTERNET CONTROLS" and press OK.

I believe Acc97 have this.

 

[Accessdabbler]

Hmm, didn't find anything called References under Tools. Under Insert I can add an ActiveX control called Microsoft Web Browser.

However, there is no option for Navigate. I'm wondering if there is some plugin or option I need to install.

 

[nice95gle]

You need to be in the Module window, the window where the code is written.
You are in the design view of a form NOT THERE.