asked on

Lotus 1-2-3 to Excel migration

Shortly, our department will be migrating to Windows 7 and Office 2010. In light of that we're working on getting all of our users up to speed. Unfortunately, we have some users that use Lotus 1-2-3 spreadsheets. If wouldn't be that big of an issue if the spreadsheets didn't include some detailed macros. Does anyone know of any tools that are available to convert an old spreadsheet like Lotus 1-2-3 to Excel with included macros?

Thanks in advance!

ASKER CERTIFIED SOLUTION

2toria

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ArticalBadBoy

I performed Lotus to Excel migration for Millennium Compliance...on 1000's of spreadsheets!
At the time, the only way we found to do it was...
1. Save the Lotus file as a .xls
2. Manually recreate the macro

We did speed things up by writing vba code to batch save the lotus files
Also, once we discovered what parts of the lotus script did, we set up a database of solutions so that as soon as someone recreated the code it was then made public to stop duplication of work.
Took a while, but got quicker using this process.

AIT-Group

ASKER

2toria - We tried the first option, but unfortunately, the converter didn't really do anything with the macros. The second option was also one that I stumbled across and I've been trying to find a wk4 converter. I may have to just track down an old copy of excel

BadBoy - We've been going your route and doing them by hand so far. If I can avoid that for the rest that haven't been done, I'd prefer that.

I'll continue my research and let you know what we come up with here.

Thanks for the input!

AIT-Group

ASKER

I have either been doing or have tried the solutions presented.