It’s not so much a VBA question, but an HTTP question. You can program the
control of any web site  usually, but you get into the world of GETs and
POSTs and HTTP. Using “Microsoft WinHTTP Services” you can either do a GET
or a POST to a web  site and get the HTML results back, then you can parse it
up for the results you’re looking for. Not the easiest thing  in the world,
but that’s how you do it.
So if you use Tools / References in VBA, you should find “Microsoft WinHTTP
Services”, then you can instantiate the correct objects and such. You’ll
need to do more research on the web for specifics.