Call IE with local html page loaded from Access ?

[Isis]

How can I call IE6 from Access using VB and have it load a specified local
file.htm ?

Any help much appreciated

 

[Arvin Meyer [MVP]]

Try using the ShellExecute API:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Isis]

Try using the ShellExecute API:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Arvin, thanks very much for the reply - I looked at the example you
mentioned but I dont know (& it does not say !) where you put the code
that is listed ! There seems to be several logical blocks - can you tell
me where they all go ?

Thanks again

 

[Douglas J. Steele]

Copy everything between the Code Start and Code End statements, and paste it
into a brand new module. When you save the module, make sure you don't name
the module the same as any of the routine inside it.

To open a particular file, you'd then use:

Call fHandleFile("C:\Folder\File.htm", WIN_NORMAL)

 

[Arvin Meyer [MVP]]

Or because he wants to open IE to a particular web page:

fHandleFile("http://www.mvps.org/access", WIN_NORMAL)

 

[Isis]

Or because he wants to open IE to a particular web page:

fHandleFile("http://www.mvps.org/access", WIN_NORMAL)

Arvin,

Thanks very much for taking the time to explain that - it works perfectly
- I appreciate it.

Regards

 

[Douglas J. Steele]

Ah. I'd read "load a specified local file.htm" as meaning an htm file on his
hard drive.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[Isis]

Ah. I'd read "load a specified local file.htm" as meaning an htm file
on his hard drive.

In fact that is what I meant but this method is good because it is
versatile - and it solves my problem.

Thank you both.

 

[chris.nebinger]

I'd go for simplicity:


Application.FollowHyperlink "http://www.msnbc.com"

 

[Isis]

Application.FollowHyperlink "http://www.msnbc.com"

Thanks for this method as well Chris - simplicity is always elegant.

Regards