Taken largely blind with some cheap eBay macro tubes in Mum’s garden. Turned out interesting, certainly $12 worth of interesting anyway.
There are pre-built Access functions to export data to Excel, such as the DoCmd.TransferSpreadsheet or DoCmd.OutputTo method, but anything but the most basic reports will require you to customise the Excel output more than these functions will allow. This code shows you how to create an instance of Excel and export the contents of the table into a […]
Another quick one… Download Excel Snake
A car alarm started going off at 5am this morning, forcing me out of bed… on the upside I had a chance to take pictures of the nearly full moon. Click for full size.
Example of the popup calendar when used inline on a spreadsheet. The VBA editor does not have a calendar control available to it by default – however it is possible to use the MS Access calendar control. This tutorial is on how to set up a calendar control that can be accessed via a UserForm, […]
Made this over lunchtime yesterday… it’s not pretty, but just seemed to be an obvious idea. Only tested in Excel 2003. Download Life.xls
Countdown.xls Excel VBA countdown clock. Compatible with Excel 2007.