Automated File Conversions 31-Aug-09

Purpose: Convert Lotus 1-2-3 files in specified subfolders into Excel files in corresponding subfolders.

Unlike Excel 2000 or 2003, Excel 2007 does not read Lotus 1-2-3 files. If you need to support Lotus files and you are migrating to Excel 2007, the initial step might be to manually load each Lotus 1-2-3 file into Excel 2000, Excel 2003, or a converter program. Then you could manually save each file as an Excel (.xls) file. This implementation automates, organizes, and documents the conversion process using Excel 2000 or 2003.

In a typical example, each subfolder in the source folder might contain Lotus files for one person. Subfolders might be placed within department subfolders. Files can be included at any level. The Results Log is cleared only when requested by the user.

When run in Excel 2000 or 2003, this application will create Excel files from Lotus 1-2-3 files. Each run will automatically:

  1. Identify all files in the source folder and its subfolders that match the selection criteria.
  2. Inform the user regarding
  3. Prompt the user whether to continue processing.
  4. If continuing, read the matching files into Excel.
  5. Create corresponding subfolders under the destination folder if necessary.
  6. Save the Excel files into the corresponding subfolders.
    (Any existing Excel files will not be overwritten.)
  7. In the Results Log (shown above), record file information and comment on the results.

You can obtain a fully functional evaluation copy by contacting Arthur Little at Standard liability disclaimers would apply. For a fee, you may also obtain full rights to use this application for specific business purposes, and the source code may be unlocked and/or modified to meet your requirements.