the lines below full code.
[problem] vba form displays google , enter value of "best radio" , clicks button. 1) 438 error shows after successful google page "best radio" entered. 2) 'google search' button clicked, if press enter key, google shows search result.
option explicit dim objie private sub commandbutton1_click() set objie = createobject("internetexplorer.application") objie.top = 0 objie.left = 0 objie.width = 800 objie.height = 600 objie.addressbar = 0 objie.statusbar = 0 objie.toolbar = 0 objie.visible = true objie.navigate ("http://www.google.com") doevents loop until objie.readystate = 4 objie.document.getelementbyid("lst-ib").value = "best radio" objie.document.getelementsbyname("btnk").click sendkeys "{enter}" doevents loop until objie.readystate = 4 msgbox "complete" end sub
remove objie.document.getelementsbyname("btnk").click. google page opens ok , results 'best radio' displayed.
explanation: problem lies in page being interactive , automatically changing home results page before hit 'enter'. thereby btnk button removed can no longer click (but trying to). that's why excel fails.
