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:
Dim...
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:
50% Complete
Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!