By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

How do I launch Internet Explorer

P: n/a
Hi

I need to get access to refresh a page of internet explorer.

Call Shell("C:\Program Files\Internet Explorer\Iexplore.exe
http://www.google.co.uk", 1)

This works, but it creates a new instance of iexplore everytime.
So instead of launching lots of iexplore windows, does anyone know
enough about vba to suss how to make iexplore refresh a page.

Cheers
Phil.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
go**********@budget-edi.co.uk wrote:
Hi

I need to get access to refresh a page of internet explorer.

Call Shell("C:\Program Files\Internet Explorer\Iexplore.exe
http://www.google.co.uk", 1)

This works, but it creates a new instance of iexplore everytime.
So instead of launching lots of iexplore windows, does anyone know
enough about vba to suss how to make iexplore refresh a page.

Cheers
Phil.


Well, you need to get the IE object. Do this by making a reference to
the "Microsoft Internet Controls" library (shdocvw.dll). then...

Dim ie as InternetExplorer
set ie = GetObject(, "InternetExplorer") 'gets a running IE instance...

....

Look for code on that, because then you want to get the current page,
and then you should be able to refresh it.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.