Automate Data Entry from .xls to IE
Sorry, that didn't wrap properly.
Just go to Yahoo, put "Australia" in the search box and click
"Search", then copy the resulting URL and use it as the variable.
Yahoo puts the search term in the URL so it's simple to automate going
to their website.
For example:
Dim AskMe as String
AskMe = Inputbox("What would you like to search for?")
sURL = "http://search.yahoo.com/search?p=" & AskMe & _
"&fr=yfp-t-501&toggle=1&cop=mss&ei=UTF-8"
If you wanted the same thing from Google it would be:
sURL = "http://www.google.com/search?hl=en&q=Australia"
HTH,
JP
On Jan 21, 11:31*am, JP wrote:
How about
sURL = "http://search.yahoo.com/search?p=Australia&fr=yfp-
t-501&toggle=1&cop=mss&ei=UTF-8"
HTH,
JP
|