Sendkeys
 

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.

Sendkeys
 

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.


"wangww" wrote:

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.

Sendkeys
 

Or even simply

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

Regards,
Peter T

"wangww" wrote in message
...
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.