launch internet explorer from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pradip Jain - 30 Jul 2008 13:21 GMT

i use the following code to launch Internet Explorer from excel. It works.
Problem is after the page is open i want to refresh the window automatically.
how to do that??

Sub LaunchIE_FSA_11()

Set ie = CreateObject("InternetExplorer.Application")
ie.AddressBar = False
ie.MenuBar = False
ie.Toolbar = False
ie.Width = 610
ie.Height = 700
ie.Left = 0
ie.Top = 0
ie.navigate
"http://www.nseindia.com/marketinfo/equities/cmquote_tab.jsp?key=GAILEQN&symbol=G
AIL&flag=0"
ie.resizable = True
ie.Visible = True
End Sub

ie.Refresh = True, does not work. please help. TIA

Reply to this Message

Gary''s Student - 30 Jul 2008 14:31 GMT

There is probably some kind of refresh Method in the IE Object Model, but
here is a way to have VBA do what the user does: touch F5 in IE for a
refresh:

Sub LaunchIE_FSA_11()

Set ie = CreateObject("InternetExplorer.Application")
ie.AddressBar = False
ie.MenuBar = False
ie.Toolbar = False
ie.Width = 610
ie.Height = 700
ie.Left = 0
ie.Top = 0
ie.navigate "http://www.cnn.com"

ie.resizable = True
ie.Visible = True

MsgBox ("ready to refresh??")
AppActivate ie
SendKeys "{F5}"
DoEvents
End Sub

Signature

Gary''s Student - gsnu200796

> i use the following code to launch Internet Explorer from excel. It works.
> Problem is after the page is open i want to refresh the window automatically.
[quoted text clipped - 17 lines]
>
> ie.Refresh = True, does not work. please help. TIA

Reply to this Message

Pradip Jain - 31 Jul 2008 11:48 GMT

although it works, not a very neat solution.

anybody else has a better alternative - please help

> There is probably some kind of refresh Method in the IE Object Model, but
> here is a way to have VBA do what the user does: touch F5 in IE for a
[quoted text clipped - 42 lines]
> >
> > ie.Refresh = True, does not work. please help. TIA

Reply to this Message

Gary''s Student - 31 Jul 2008 17:28 GMT

I agree, it is not very neat.

How about just repeating the Navigate statement whenever you want to refresh??

Signature

Gary''s Student - gsnu200797

> although it works, not a very neat solution.
>
[quoted text clipped - 46 lines]
> > >
> > > ie.Refresh = True, does not work. please help. TIA

Reply to this Message