Visual Basic for Applications

Chapter 11. HTML and the Web

Visual Basic for Applications Chapter 11.
HTML and the Web

Downloading a web page

To download a web page in VBA, you can make use of the Microsoft XML, v6.0 (MSXML6) library, which enables server HTTP requests.

Parsing HTML

In VBA, you can parse HTML using the Microsoft HTML Object Library.

Sending an HTTP request

The key to sending an HTTP request in VBA is utilizing the Microsoft XML, v6.0 library (or older versions, depending on your system).

Sending an HTTP request with basic authentication

In VBA, you can use the Microsoft XML, v6.0 (MSXML2) library to send HTTP requests with basic authentication.