Hi There,
I have a spreadsheet with a list of roughly 5,000 URLs in a column. I would love to have a macro that would:
- Follow each hyperlink in sequential order;
- Search for a particular phrase (e.g., "download here");
- Highlight each cell containing a URL that driects to a page with that phrase;
- Close any tabs or windows that are opened in the process;and
- Upon searching the final item in the list, provide some message (e.g., "Complete").
Ideally, I would love it if it could check each item in the list automatically without requiring some sort of action between each URL, such as closing the window or confirming the next search. They tell me it can't be done. I have my doubts. They are always naysaying. I'm hoping the good folks at Excel Forum know better. Any ideas would be much appreciated.
Thanks in advance!
Jon
Bookmarks