How To Read A Program
by Steve Kilner

When you have to figure out a big, complicated program you're not familiar with, what do you do? Can you explain the process you go through? If you’re a manager of people who maintain programs, what do you know about how they figure out programs? How are they doing it? Are they doing it efficiently? Correctly? READ MORE >

Load a Spreadsheet from a DB2/400 Database: Part 3
by Michael Sansoterra

Part 1 and Part 2 of this little series on generating an Excel spreadsheet demonstrated how to use Visual Basic for Applications (VBA) code to retrieve data from DB2 on an AS/400 and place it in a spreadsheet. Additional refinements were offered on doing some fancier things to the spreadsheet, such as auto-sizing all the columns based on the loaded data, formatting date columns properly, etc. All of this was done in the name of programmatically creating a nice spreadsheet with current 'DB2 for i' data. This tip is going to add one little tidbit to the mix. I want to address how to populate multiple worksheets within a single workbook. READ MORE >