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

Closed
ajaydwivediji Posts 14 Registration date Tuesday October 30, 2012 Status Member Last seen January 5, 2017 - Nov 9, 2012 at 10:39 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2012 at 08:22 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Dec 1, 2012 at 08:22 AM
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