bsharath
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;"><s pan style="font-family:arial,h elvetica,s ans-serif; ">
Sample
http://tinyurl.com/bzl8lpb
Excel macro or a vbs would be helpful
regards
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;"><s
Sample
http://tinyurl.com/bzl8lpb
Excel macro or a vbs would be helpful
regards
ASKER
Thanks
I am not a programmer
Can you please help with the code?
I am not a programmer
Can you please help with the code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
seems like it works
Have a query
does it check
<span style=""font-size:12px;"">
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
Kris
ASKER
When the formulas are reading the screen freezes so it only gets to editable mode when the formulas have retrieved
ASKER
Anyway i can add 2 things to check within it?
Also any way to speed up?
Also any way to speed up?
http://stackoverflow.com/questions/11429235/excel-vba-website-source-code-buffer-size