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"?
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"?
