In sticking with your quick and dirty theme...
Never the less, the results were fairly accurate. Unfortunately, I do not have a MAC. This code utilizes the internet explorer webbrowser control. Is this installed with office for MAC? I don't know...
Is fairly slow but would be good enough for me for an occasional run... Saves the workbook at every 50th row.
Download the example or follow the instructions below. There is a list of companies in in column a that I tested this on. Disable script debugging. See comments in code...
Download Example Workbook
Add UserForm1 with WebBrowser1.
There is no code in the userform.
Select your URL list and name it UrlList.
Add this code in a public class module. Any worksheet or the workbook class will do.
Bookmarks