Extract information from website into Excel Table (no API)

[Frankie26]

Hi All,


Is it possible to extract data into an excel table without the use of API?


For example, I would like to goto the below website, search by CUSIP (13063A7D0 if an example helps), use trading activity (one of the headers), and extract all the trades for a certain date.


https://emma.msrb.org/


This sounds like it might be a job for Javascript, but I figured I'd try my luck with VBA since I have some experience there.


Any help or push in the right direction is very much appreciated!