Using Hyperlink and VBA

[ifoundgoldbug]

Greetings

I am looking to see if it is possible to use a hyperlink to open a
search engine like google Fill the search bar with data from my table
and generate a click. I have done somethign similar to this in VB6
about 3 years ago but I don't know if VBA has this capability. any help
would be appreciated.

Thank you for your time

Gold Bug

 

[Ron2006]

There is a command....

application.followhyperlink stringofaddresstofollow

If you can format that string to be what the search engine would create
if you were at the website and entered the string to search for and hit
enter, then it can be done that way.


There may be other easier ways, and if so I would be interested also.

Ron

 

[ifoundgoldbug]

yea following the hyperlink is easy it is the problem of finding the
..click property and the proper module like I said it existed in VB6 but
I don't think that vba has it