How to refresh IE using VBA

Question

I have been trying to figure out a way to refresh internest explorer through VBA. I have a webpage I need to refresh periodicly and I need VBA or something to refresh it. Do you guys know of a way to get VBA to refresh a webpage?

Do you mean VBA to automate a webpage from scratch and get data, or you have an instance of IE running already and you want to refresh it? — brettdj, Dec 30 '11 at 13:19
Could you use GetObject to grab the instance and then use the Refresh method? — JimmyPena, Dec 30 '11 at 16:21

score 2 · Accepted Answer · edited Dec 31 '11 at 01:02

2

To use this code which applies Early Binding you will need to add a reference to "Microsoft Internet Controls" in the Visual Basic Editor

This code will open IE, go to google, wait for the page to load completely, then refresh.

Sub RefreshPage()

  Dim page As New InternetExplorer      
  page.Navigate "www.google.com"
  page.Visible = True      
  Do
  Loop Until page.ReadyState = READYSTATE_COMPLETE
  page.Refresh

End Sub

edited Dec 31 '11 at 01:02

brettdj

54,857
16
114
177

answered Dec 30 '11 at 23:15

Justin Self

6,137
3
33
48

This is fine if the OP wants to create a new instance but we are yet to hear if this is the case. Also, suggest you separate the `Dim page As New InternetExplorer` into two lines – brettdj Dec 31 '11 at 01:00
@brettdj: Why do you suggest seperating "Dim page as New InternetExplorer" onto two lines? – waqasahmed Jan 06 '12 at 11:40
option infer on and then use = new instead of as new. as new is very strange. It creates a new instance when you use it. Which is pretty unpredictable. – user4951 Mar 22 '17 at 17:44

How to refresh IE using VBA

1 Answers1