I have written a VBA code (function) to check whether a URL exists and returns true if it exists. Now I want to further check the page for a known text (in HTML) for example
- to check whether a google map exists in the page
- to check whether a image (known file name) is embedded in the page
- to check whether a youtube link exists in the page etc.
The text to search ( or URL) can be kept in a column. I'm looking on how to write a function to do this. I know A web query can be used in certain situations, but in this case the webpage im searching may not be structured in a known manner. (i.e I cant write a query to search for this bcos it may not be in a table.) Actually I want to check whether some of my students have created webpages which includes above activities which I can check automatically)
Thanks in advance
- to check whether a google map exists in the page
- to check whether a image (known file name) is embedded in the page
- to check whether a youtube link exists in the page etc.
The text to search ( or URL) can be kept in a column. I'm looking on how to write a function to do this. I know A web query can be used in certain situations, but in this case the webpage im searching may not be structured in a known manner. (i.e I cant write a query to search for this bcos it may not be in a table.) Actually I want to check whether some of my students have created webpages which includes above activities which I can check automatically)
Thanks in advance
