Because of Sarbanes-Oxley, we have a new requirement in our shop that all source members must include comments that tell the usual stuff–who did what, when and why they did it, etc. While we have always done that sort of thing (well, most of the time), there are certain types of source members we never bothered to comment. A good example is ILE binder language. I’ve looked for, but never found, a document that tells how to comment binder language. Do you know?

–Pat

IBM didn’t make it easy for you, Pat. I wondered the same thing myself a while

Note: The code for this article is available for download here

Ted Holt’s tip on loading database data into Excel was great. I’d like to offer a few potential enhancements to the VBA code that was offered in the tip.

The first thing that I would like to note is that if you want to copy all rows and columns from an ADO recordset (an object that holds the results of a query) into the spreadsheet, then there is a CopyFromRecordset method of the Range object to do this:

ws.Range("A2").CopyFromRecordset Rs

In the original code sample, row one was reserved

When writing a weekly column like Admin Alert, mistakes can inadvertently sneak into the final copy. Fortunately, I have alert readers (pun intended) who correct me on any errors that I may have made, providing me with additional information on many topics in the process. So in the spirit of setting the record straight, here are some reader-provided corrections and additions to material that I published in earlier columns.

Corrections of FSB Meditations

In my recent column on Full System Backups, I wrote that IBM’s Save System Information command (SAVSYSINF) allows you “…to save the cumulative changes that have