MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Lotus123 to Excel

Posted by Steve W on March 25, 2001 1:28 PM

Does anyone know an easy way to convert lotus workbooks to excel. The lotus programs has multiple workbooks linked together. I know that sometimes formulas get lost in the transition.
I am just curious if there is any programs or VB code that can accomplish this.

Thanks Steve W.

Posted by Dave Hawley on March 25, 2001 7:27 PM

Hi Steve

Have a look at this link:


OzGrid Business Applications

Posted by mseyf on March 26, 2001 5:25 AM

if you're using Excel97, there's a 'File Conversion Wizard' on the installation CD that is not part of the 'normal' installation. It has worked quite well for me, except for converting ISEMPTY() and XINDEX().

You can check the MS Knowledge Base articles for more (Q161325 & Q235473 for starters.)