We help IT Professionals succeed at work.

Lotus 1-2-3 to Excel migration

AIT-Group
AIT-Group asked
on
664 Views
Last Modified: 2013-11-11
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!
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
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.

Author

Commented:
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!

Author

Commented:
I have either been doing or have tried the solutions presented.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.