Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

Check all URl's if the page source has this content

Hi,

I want help with a script that read all URL's in the file and check the page source and gives yes/No

This below line should be searched

<span style="font-size:12px;"><span style="font-family:arial,helvetica,sans-serif;">


Sample
http://tinyurl.com/bzl8lpb

Excel macro or a vbs would be helpful

regards
Avatar of Pratima
Pratima
Flag of India image

Avatar of bsharath

ASKER

Thanks
I am not a programmer
Can you please help with the code?
ASKER CERTIFIED SOLUTION
Avatar of krishnakrkc
krishnakrkc
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks
seems like it works

Have a query

does it check

<span style=""font-size:12px;""><span style=""font-family:arial,helvetica,sans-serif;"">

if available in page then TRUE?

As page source a few that it does not have this exact line is also shown as TRUE
this might be a performance issue. Rather than draging the formula go cell by cell.

Kris
When the formulas are reading the screen freezes so it only gets to editable mode when the formulas have retrieved
Anyway i can add 2 things to check within it?

Also any way to speed up?