VBA to collect internet search term hyperlinks

[MikeZiller]

Hi there,

I'm interested in tracking the news, and I was wondering if there was a way to set up a formula to track an internet search engine every so often and paste that information into excel.

When copying data from within the web, I'm not able to extract the web link, which would be helpful.

I'm trying to get the information that a Google search provides: headline, publication, date and link.

Is this possible? :dunno

-Mike

[Kenneth Hobs]

Welcome to the forum!

Please provide a specific example manually marked up. Attach an xlsx or xlsm file to show what you want both before and after running a macro. The devil is in the details.

[SamT]

Google doesn't provide links per se. It uses PHP scripts to return a web page to the browser. You will have to pick the link out of the google link text.
http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CC8QFjAA _
&url=http%3A%2F%2Fwww.vbaexpress.com%2Fforum%2Findex.php _
&ei=G-5uUdGMCM6yigKhoYHABQ&usg=AFQjCNGEX1GaKGBer6m-cNtsJXZYq-bpDQ&bvm=bv.45368065,d.cGE