The site formerly known as Code For Excel and Outlook
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: Reference latest version of DBEngine »
April 25, 2011 by · 
There's a nice article over at Colin Legg's site that shows you how to check what Office edition is installed. I've thought of some other ways to do something similar.
Continue Reading: Check if Office is installed »
July 30, 2010 by · 
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: An Introduction to YQL for VBA »
June 8, 2010 by · In a previous post I promised to go through a real example of how we can automate Internet Explorer to retrieve data from a website. We'll also enumerate some of the members of the IE Document Object as well as see how we can incorporate XMLHTTP into the mix.
Continue Reading: An exploration of IE browser methods, part II »
Site last updated: February 9, 2012
Follow Me