Thread: Sendkeys
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.