Excel VBA Technology & Digital Applications 2

Question 1

Which VBA method is used to send an HTTP GET request using the MSXML2.XMLHTTP object?

Accepted Answer

Open

Answer

The Open method initializes a request on MSXML2.XMLHTTP, specifying the method (GET/POST) and URL before calling Send.

Question 2

When automating a web browser with VBA using Internet Explorer automation, which library reference must be enabled?

Accepted Answer

Microsoft Internet Controls

Answer

Microsoft Internet Controls (shdocvw.dll) provides the InternetExplorer object used for IE automation in VBA.

Question 3

In VBA, which function converts a JSON-like string value retrieved from a web API into a usable number?

Accepted Answer

CDbl

Answer

CDbl converts a string representation of a number to a Double data type, suitable for numeric calculations after parsing API responses.

Question 4

What VBA statement is used to create a new instance of a late-bound COM object without a reference set?

Accepted Answer

CreateObject("ProgID")

Answer

CreateObject creates a new instance of a COM object using its ProgID string, enabling late binding without requiring a library reference.

Question 5

Which Excel VBA object model class allows you to interact with Power Query (Get & Transform) connections programmatically?

Accepted Answer

WorkbookQuery

Answer

The WorkbookQuery object (accessed via Workbook.Queries collection) represents a Power Query query defined in the workbook.

Excel VBA Practice Test