Converting from Lotus 1, 2, 3 docs

M

Michael Miazga

I have a user who has a bunch of Lotus 1, 2, 3 spreadsheets that he is
trying to convert to Excel. His version of Lotus is old (version 5), his
version of Excel is 2000 sp2. The files convert but they are missing pages
or headings or other unacceptable qualities. Anyone any advice?
 
E

Ed

Michael

If you open the files using Excel and save them to an .xls format in the
current version you are losing data?

A while back I needed to do this. I wrote an application in VB that loops
through the files, opens them using Excel (add a reference in VB to MS
Office 10) and then save them in the current version. I have not
encountered any issues with data being lost.

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Lotus in Excel 2007 1
Excel 2003 - importing lotus files 2
Lotus 1-2-3 file with Excel 2003 1
execl to lotus 1-2-3 conversion 1
Excel Lotus 1-2-3 transition for Excel 2007 1
Is Lotus 1-2-3 conversion possible? 1
What version of Excel converts Lotus 1-2-3 spreadsheets? 1
How can I open up a Lotus 123 spreadsheet in Excel 2007? 2

Top