In addition to the techniques described in Rest to Excel library, it is possible to use an internet explorer object to access the DOM directly from VBA.
This condensed article is from an original by a guest contributor, Petros Chatzipantazis of spreadsheet1.com.
The registry is used by applications (e.g. Internet Explorer) and Windows to store configuration data.
Although VBA includes the SaveSetting and GetSetting functions to save and retrieve information from the registry, these functions only operate on a specific section of the registry, the Visual Basic and VBA Program Settings of the HKEY_CURRENT_USER root key.
The code below demonstrates how to use 32/64 bit Windows API functions to set values anywhere in the registry
e.g. as required to toggle the ‘Show pictures’ option of Internet Explorer.
The Win64 conditional compilation constant is used to test whether code is running as 32-bit or as 64-bit.
In versions of VBA prior to Excel 2010, there was no specific pointer data type so the Long data type was used. And because the Long data type is always 32-bits, it breaks when used on a system with 64-bit memory, because the upper 32-bits may be truncated or may overwrite other memory addresses.
Either of these situations can result in unpredictable behavior or system crashes. To resolve this, VBA now contains a true pointer data type: LongPtr. This new data type enables developers to write valid Declare statements for execution with the 64-bit version of Office 2010.
Thanks again to Petros for his contribution. Why not join our forum, follow the blog or follow me on Twitter to ensure you get updates when they are available.