pass field contents to google.com

[johngordon]

I have an address field that I want to be able to pass data to a google.com web page.

Can this be done? If so, can some help me out with some code. I'm lost!

Thanks,

John

 

[mdav2]

I don't think you can pass data like that. You could try and fiddle it by doing a search, copying the URL. I did this using "TEXTOFSEARCHHERE" as my search string and got this URL:

"

http://www.google.com/search?hl=en&ie=ISO-8859-1&q=TEXTOFSEARCHHERE&btnG=Google+Search"

Now create some simple code to open the URL using a predefined string is shown below:

Code
----
Dim strInput As String

strInput = "

http://www.google.com/search?hl=en&ie=ISO-8859-1&q=TEXTOFSEARCHHERE&btnG=Google+Search"

Application.FollowHyperlink strInput, , True

--- End of code ---

If you want the user to put a specific search query in then have a textbox (called txtInput as an example) and substitue this into the code like so:

Code
----
Dim strInput As String

strInput = "

http://www.google.com/search?hl=en&ie=ISO-8859-1&q="

+ me!txtInput.value + "&btnG=Google+Search"
Application.FollowHyperlink strInput, , True

--- End of code ---

This should do the trick

 

[johngordon]

Thanks a million! I took your advise and fiddled with it a little and it worked fine!