Vallo
10-07-2010, 12:08 PM
Hello everybody :),
I'm new to the forum and I hope that you will be able to help me with what I'm trying to achieve.
I have recently started studying VBA for Excel and I'm writing a macro which, at the moment allows me to open Internet Explorer, open the web page "google.com", type a keyword on the search box and run the search. Everything fine here.
Now I'm trying to search for a specific link in the results and click on it (if it appears in the page), and here I'm having an issue..
I looked at the HTML code of the google results page, but the results are nowere to be seen (I cant see the actual links to the websites) so I don't know how to tell VBA how to look for the link to be searched.
For example: after searching the word "apple" in google, I want to search the link "Cake (band) - Wikipedia" and click on it.
Does anybody have an idea about what I'm talking about and how to do this thing please?
Many thanks in advance :)
I'm new to the forum and I hope that you will be able to help me with what I'm trying to achieve.
I have recently started studying VBA for Excel and I'm writing a macro which, at the moment allows me to open Internet Explorer, open the web page "google.com", type a keyword on the search box and run the search. Everything fine here.
Now I'm trying to search for a specific link in the results and click on it (if it appears in the page), and here I'm having an issue..
I looked at the HTML code of the google results page, but the results are nowere to be seen (I cant see the actual links to the websites) so I don't know how to tell VBA how to look for the link to be searched.
For example: after searching the word "apple" in google, I want to search the link "Cake (band) - Wikipedia" and click on it.
Does anybody have an idea about what I'm talking about and how to do this thing please?
Many thanks in advance :)