Sendkeys

[wangww]

Sub SendURL()
Shell "C:\Program Files\Internet Explorer\iexplore.exe", vbNormalFocus
SendKeys "www.google.com", True
End Sub

This procedure can open IE, but the URL isn't entered into address bar.

 

[Mike H]

Hi,

If you hard coding the URL why bother with sendkeys, why not like this

MyPage = Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE
http://www.google.com", vbNormalFocus)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Peter T]

Or even simply

ThisWorkbook.FollowHyperlink "http://www.google.com"

Regards,
Peter T