News, views and articles from our membership
I can't claim the original idea for this article. The concept actually comes from Professional Excel Development, but I developed the code, such as it is here, on my own. The reason for this was because I couldn't find it in the book when I went looking for it, so I knocked up my own version, and decided to post that here.
Continue Reading: Creating a Debugging Mode »
Introduction:
On occasion, we may want to create a database on the fly to store information. This can seem a daunting task, but in reality it is quite simple once you know how. To this end, this article describes the steps necessary to do exactly that! The following routine will create an Access database from any VBA enabled application, such as Word, Excel, Outlook, etc…
Continue Reading: Creating an Access Database (on the fly) Using VBA and SQL »
This article explains how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings.
Continue Reading: How To Retrieve Data From A Database To Excel Using VBA, ADO & SQL »
Introduction
Every now and then, you may need to send an email from another application through Outlook. If you've ever thought about automating this process using Outlook 2000, Outlook 2002 or Outlook 2003, then no doubt you've run into the dreaded Outlook security prompt upon trying to send:
Continue Reading: Send Email Using ClickYes »
Follow Us