Archive of Mr Excel Message Board

Back to Lotus archive index
Back to archive home

Lotus to excel file conversion

Posted by Carolyn VanEman on October 15, 2001 6:43 AM

We are in the process of changing our company standards to Microsoft 2000. Currently we are using Lotus 97. Is there a utility which will automate the conversion, both extensions wk* and 123 are in use. We are looking for something that would convert macros also.

Any assistance and advice on this project would be greatly appreciated. The volume on the conversions is very large and will be time consuming with out some automation.

Thanks
CVE

Re: Lotus to excel file conversion

Posted by Joe Was on October 16, 2001 8:54 AM

All the utilities drop macros. Excel and Lotus have different macro languages. Your only option is a re-write. Excel will convert data on a worksheet and some formulas, but some formatting will change and the macros will fail. Joe Was

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.