Lotus Notes was innovative and, by most accounts, a great collaboration software in its heyday. Though there are still some 35 million users of Notes, there are regular rumors of its imminent demise. Because of this, some organizations that have used Notes over the years may want to move to some other system, such as … Read more
A new problem I was tasked with was to make enhancements to a report built using CFML by changing the totals column to a SUM() function when the report is exported to Microsoft Excel. The trick here was that the table was being exported as HTML code, and then opened in Excel. Since the location … Read more
In adding functionality to an ancient Excel VBA reporting app for an Oracle database, I decided to set up a temporary worksheet to use as a place to store data before copying it to multiple other worksheets rather than copying directly from the recordset multiple times. Basically, this VBA procedure takes an ADODB recordset and … Read more