I have a database that only allows exporting in Lotus 123 format. I saved 10
different worksheets in a folder and now I would like to open all 10 into 1
Excel Work Book.

Each Lotus 123 file would have it's own tab in this new Excel Work Book. Is
there an easy way to do this without opening each file and copy/pasting into
the new Excel Work Book?

Thanks

I don't know how well it works, but in Excel Open File there is a Lotus 123
option.


Years ago I had to read Lotus 123 into Excel. I had quatro Pro (anotherr
spreadsheet). In quatro Pro I was able to read Lotus 123 and write the files
as Excel.

"simond" wrote:

I have a database that only allows exporting in Lotus 123 format. I saved 10
different worksheets in a folder and now I would like to open all 10 into 1
Excel Work Book.

Each Lotus 123 file would have it's own tab in this new Excel Work Book. Is
there an easy way to do this without opening each file and copy/pasting into
the new Excel Work Book?

Thanks