Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem filling out form on internet using macro

Status
Not open for further replies.

DrMingle

Technical User
May 24, 2009
116
US
I need help with the below code...

I am attepting to go to the business search and fill in some of the data on website....

Sub WhitePagesEntry()

Dim objIEWP

Set WshShell = CreateObject("WScript.Shell")
Set objIEWP = CreateObject("InternetExplorer.Application")
objIEWP.Visible = False

objIEWP.navigate2 "objIEWP.Visible = True
While objIEWP.busy
Wend
objIEWP.Visible = True
objIEWP.Visible = True

WshShell.AppActivate "Name or Category"
WshShell.SendKeys "{TAB}"
WshShell.SendKeys "{TAB}"
Name = "medical center"
WshShell.SendKeys Name

WshShell.SendKeys "{TAB}"

WshShell.SendKeys "37211"

WshShell.SendKeys "{TAB}"

WshShell.SendKeys "{TAB}"

WshShell.SendKeys "{TAB}"

WshShell.SendKeys "{Enter}"

End Sub
 
Have a look here:
faq707-6399

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top