This is the CreateObject tag.

The CreateObject tag means that the article deals with automation, either MSXML or Internet Explorer, or even Outlook.

Access icon

Reference latest version of DBEngine

In How to get most recent DBEngine object, Access MVP Alex Dybenko shows us some VB.NET code for grabbing the latest version of DAO's DBEngine Object.

It smartly uses a loop to start from the newest version and walks its way down to the lowest version, trying to set an object reference each time. But the VBA version of the same code just hardcodes each version. Why not loop in VBA as well?

Continue Reading »

VBA icon

An Introduction to YQL for VBA

YQL logo

YQL is a flavor of SQL that allows you to query Yahoo's databases in a simple way. In Yahoo's words:

The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint.

Yahoo! and other websites across the Internet make much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endure the pain of locating the right URLs and documentation to access and query each Web service.

With YQL, developers can access and shape data across the Internet through one simple language, eliminating the need to learn how to call different APIs.

Continue Reading »

Random Data Generator