As I thoroughly explain and demonstrate in my online course: Beyond Excel Boundaries with VBA: Office, Files and Internet, you can send any HTTP request over an Internet connection from VBA using the WinHttp service library. Here’s a code snippet to send a request to some URL:
The idea for this Blog post came as I was forwarded a similar question on Quora to answer. I’ll offer my perspective for the discussion on this question.
First, let’s consider your requirements. The following list will help us frame the discussion: