In Import data to Access from Excel and My first Access macro, I posted some Access macros that push data into Access. Here is some code that does both.
Continue Reading: Pushing and Pulling Access around »
Extract Calendar data from Outlook, Redux
March 31, 2009 by · 
In Extract Calendar Data from Outlook into Excel, I posted a method for writing Outlook appointments to an Excel worksheet.
Here is an updated function that uses a bit less code, with one disadvantage: it doesn't extract recurring appointments. Use the original code if you have recurring appointments. Or use both; the original to get all appointments, and this one to get only originals (not the recurrences).
Continue Reading: Extract Calendar data from Outlook, Redux »
Export Excel Range to a Picture File
November 13, 2008 by · (See my followup post Export Excel Range to a Picture File, Redux for updated VBA.)
If you ever needed to capture a range, for pasting into a document or email, you'll need to save it as an image first. If so, you might find this routine useful. It takes a contiguous range, starting in A1, and creates a GIF file with a snapshot of the range.
Continue Reading: Export Excel Range to a Picture File »
Export Outlook Contacts to Excel
September 6, 2008 by · Here is the last of the add-in code I was working on. This piece extracts the properties from Contact Items into Excel, using early binding to speed up the code, but with GetObject/CreateObject calls to attempt to hook into an existing instance of Outlook. What, do you mean you don't leave Outlook running all day while you're in the office?
Continue Reading: Export Outlook Contacts to Excel »
Exporting Comments using VBA
Reading comments is hard. Well, it is for me. You have to mouse around and wait for the comment to appear. But it's easy with a bit of programming. Here's how.
Continue Reading: Exporting Comments using VBA »