Navegating through a website

Miticus

New Member
Joined
Apr 19, 2012
Messages
1
Hello everyone!

I'm fairly new to Excel and VBA altogether and i got some doubts about VBA.

Right now, i have a worksheet with several cells filled in with info.

What i want to do is go to a website and search for a few strings on the page and if i find them i want to click on the link associated to them.

Example:
"BIG Link"
"Useless string"
"Imp. String nº1" "Imp. String nº2"

My doubt is how do i read "Imp. String nº1" and "Imp. String nº2" from the page (or from the source code, don't know which one is the best or if the first one is possible) of the page and compare them with the info i have in the cells?

And how do i click the "BIG Link" after finding my "Imp. String nº1" and "Imp. String nº2"?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,257
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top