Excel VBA/Macro for Keyword based search on listed URLs.

[Closed]
Report
Posts
14
Registration date
Tuesday October 30, 2012
Status
Member
Last seen
January 5, 2017
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Greetings respected team,

Kindly advise if it is possible to create an Excel based VBA or Macro that helps search predefined keywords in predefined URLs.

If possible then,

For example we have a workbook containing three sheets, Sheet1 and a Sheet2.
[Sheet1]
- List of Predefined First Names in Column A.
- List of Predefined Middle Names in a Column B.
- List of Predefined Last Names in a Column C.

[Sheet2]
- List of URLs in a Column A.

Based on the results from the combinations of above two sheets, would it be possible to extract links from every URL where these names are appearing.

If so then we need to create a separate sheet containing URL in Column A and resulted links in Column B. Like this an output of every URLS would be created in a separate sheet of the same workbook.

For example if in an input file [SearchLink.xls] we have -
[Sheet1] - Containing names in their respective columns.
[Sheet2] - Contains a list of URLs in its respective column, say total 10 in count.

Then as an output, in the [SearchLink.xls] there would be total 12 sheets created.
[Sheet1]
[Sheet2]
[URL1]
[URL2]
[URL3]
[URL4]
[URL5]
[URL6]
[URL7]
[URL8]
[URL9]
[URL10]

The assistance on this request would be highly appreciated.

Thank you and Best Regards - AD

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
i guess when you say name apprearing in url, you meant the page that url refers too. I guess it would be possible
First via macro you would need to download that page
than scan the page for name
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month