Excel VBA Macro to Scrape Data from the Web
Budget: $10 – $30 USD
I'm looking for an Excel macro to extract specific links from multiple sites. I've got a list of (main page) URL's of different sites. I want to go to all these sites & look for to Contact page URL. I then want to download only the Contact page URL. The Contact page URL could have the keywords like /contact/ or /contact-us/ or /contactus/ or /inquiry/ or /enquiry/ or something else...Therefore, I must be able to enter these keywords in a column for Excel to loop through.
Please look at this video to understand my requirement better. https://youtu.be/w5Y1HIrYJSQ However, this video uses the archaic Internet Explorer. Preferably, I would like to use Chrome but please read the Option 1 & 2 section below for possible obstacles.
In summary, I want to find the Contact Page url automatically & just download the url. I don't need the contents of the page.
Option 1:
If you are thinking of using Chrome & SeleniumBasic, do bear in mind that Selenium runs on the archaic .Net Framework 3.5. My laptop does not allow me to download this version for some strange reason. I'm using .Net Framework 4.8. Therefore, if you are confident of getting Selenium to work on newer versions of .Net Framework, fine. Otherwise, kindly consider the simpler Option 2 below.
Option 2:
To use Excel's WebService or WebRequest function. I'm not sure if any of these will require Internet Explorer (I hope not) so you please advice me.
Additional Info:
I'm using Excel 2019 on Windows 10.
Note that if you bid above my budget, I will not reply.
Thank you.
Please look at this video to understand my requirement better. https://youtu.be/w5Y1HIrYJSQ However, this video uses the archaic Internet Explorer. Preferably, I would like to use Chrome but please read the Option 1 & 2 section below for possible obstacles.
In summary, I want to find the Contact Page url automatically & just download the url. I don't need the contents of the page.
Option 1:
If you are thinking of using Chrome & SeleniumBasic, do bear in mind that Selenium runs on the archaic .Net Framework 3.5. My laptop does not allow me to download this version for some strange reason. I'm using .Net Framework 4.8. Therefore, if you are confident of getting Selenium to work on newer versions of .Net Framework, fine. Otherwise, kindly consider the simpler Option 2 below.
Option 2:
To use Excel's WebService or WebRequest function. I'm not sure if any of these will require Internet Explorer (I hope not) so you please advice me.
Additional Info:
I'm using Excel 2019 on Windows 10.
Note that if you bid above my budget, I will not reply.
Thank you.