converting lotus 2.4 spreadsheets to excel

I'ml trying to convert a directory of many old lotus 2.4 spreadsheets to excel, with the intent of saving them in Google docs, so they will become mobile, and I could then access them in any library.

I have been advised to write a conversion program in Visual Basic. But that appears a formidable task.

The first issue was that the Lotus 2.4 spreadsheets, when opened in excel 2003 (which can be converted to google), correctly display in the window at the top of the excel 2003 spreadsheet, the contents of the cell where the cursor happens to be. Fortunately, the find and replace command works even within links, so that problem is solved.

Now I'm seeking an automated way to convert all 230 spreadsheets at once, in bulk as it were, instead of converting each spreadsheet individually, by hand. The basic idea is to write a do loop, which after it converts a single file from the old directory, wk1, and saves it in the new directory, xls, it deletes the old file from the wk1 directory, then opens another in the wk1 directory, until all files in the wk1 directory have been converted and saved in the new xls directory, and the old wk1 directory is emptied. So it doesn't matter in which order the files in the wk1 directory are selected.

I do not know how to specify a generic filename to feed into the do loop.

Thanks

longhorntex@gmail.com

j wynn, philanthropist, TX