Prev: Failed update for Outlook 2003 Junk Email Filter
Next: Excel Starts up W/Macro
From: Melissa on 26 Aug 2005 08:31
Does anyone know of any simple way to convert .123 files over to Excel in
some sort of Batch method? So far I have not had much luck.
From: Carey Frisch [MVP] on 26 Aug 2005 10:37
Conversion Utilities from Lotus 123, Wordperfect, Freelance files to their corresponding MS Office
http://www.experts-exchange.com/Applications/Lotus_Smart_Suite/Q_21030166.html

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User
Microsoft Newsgroups

-------------------------------------------------------------------------------------------

"Melissa" wrote:

| Does anyone know of any simple way to convert .123 files over to Excel in
| some sort of Batch method? So far I have not had much luck.
From: Melissa on 26 Aug 2005 11:46
This really does not explain how I would do it in batch and this discusses
..wk4 format. I am looking to convert thousands of files from .123 - .xls

"Carey Frisch [MVP]" wrote:

> Conversion Utilities from Lotus 123, Wordperfect, Freelance files to their corresponding MS Office
> http://www.experts-exchange.com/Applications/Lotus_Smart_Suite/Q_21030166.html
>
> --
> Carey Frisch
> Microsoft MVP
> Windows XP - Shell/User
> Microsoft Newsgroups
>
> -------------------------------------------------------------------------------------------
>
> "Melissa" wrote:
>
> | Does anyone know of any simple way to convert .123 files over to Excel in
> | some sort of Batch method? So far I have not had much luck.
>
From: Carey Frisch [MVP] on 26 Aug 2005 11:59
Conversions Plus!
http://www.dataviz.com/products/conversionsplus/index.html

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User
Microsoft Newsgroups

From: Harlan Grove on 26 Aug 2005 14:30
Melissa wrote...
>Does anyone know of any simple way to convert .123 files over to Excel in
>some sort of Batch method? So far I have not had much luck.

Microsoft provides *NOTHING* to do this. Excel can't open .123 files,
and there are no add-on filters for it to do so.

There are only 3 pieces of software that can work with .123 files:
Lotus 123 itself, Quattro Pro version 10 and later (for sure, and
possibly version 9), and DataViz's ConversionPlus. Of these, Lotus 123
itself is far & away the best at converting .123 files into .XLS files.

If you have thousands of .123 files to convert, then you must have had
Lotus 123 to have created them. If so, use it to convert these to .XLS
files. You'll lose LotusScript code modules, database @-functions with
criteria arguments, and most formulas that use 3D range references. No
way to avoid those losses.

Also, if you have 123, you could use 123 macros to write formula
listings of each workbook as text files. These would be very useful
when recreating formulas that were lost on conversion. As for
LotusScript code, there's no alternative to manually saving each module
as separate text files because there's no object model for the
LotusScript Editor, so no means of automating the process of saving
LotusScript code to text files.

 |  Next  |  Last
Pages: 1 2 3 4
Prev: Failed update for Outlook 2003 Junk Email Filter
Next: Excel Starts up W/Macro