Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Peter Cox
 
Posts: n/a
Default How can a file with 123 extension be opened

Is there a Lotus viewer that allows someone usining Office to open and save
Lotus 123 files as Excel files?

Many thanks!
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default How can a file with 123 extension be opened

Peter Cox wrote...
Is there a Lotus viewer that allows someone usining Office to open and save
Lotus 123 files as Excel files?


It's called Lotus 123.

Flippancy aside, there used to be a 123 viewer, but it only displayed
123 files. It didn't convert them.

AFAIK, your choices are

1. Lotus 123 itself from version 9.6 on (when Lotus introed 65,536
rows),
2. Corel Quattro Pro from version 10 (WordPerfect Office 2002) on,
3. DataViz ConversionPlus,
4. ABC Amber Lotus Converter.

None are free. #2 (from auction sites) or #4 would be cheapest.

OpenOffice 2.0 and Gnumeric claim to have .123 file import filters, but
there are problems with both.

  #3   Report Post  
Timothy L
 
Posts: n/a
Default How can a file with 123 extension be opened

KeyView for Lotus?
ftp://ftp.lotus.com/pub/lotusweb/pro...te/kvlot32.exe




Anyway...
OpenOffice.org 2.0 can open and convert Lotus files ending in .wk1, .wks, and .123.

OpenOffice.org is a free open source office suite alternative which can create, open, edit, and save Microsoft
Word Documents (.doc), Microsoft Word Templates (.dot), Microsoft Excel Worksheets (.xls), Microsoft Excel
Templates (.xlt), Microsoft PowerPoint Presentations (.ppt), Microsoft PowerPoint Slide Shows (.pps), and
Microsoft PowerPoint Templates (.pot).

Information about OpenOffice.org can be found at, well...
http://www.openoffice.org/

The latest stable release (at the time of this post) is OpenOffice.org 2.0. You can download it he
http://download.openoffice.org/2.0.0/index.html

During installation of OpenOffice.org, you will be asked if you want OpenOffice.org to automatically open
Microsoft Word Documents, Microsoft Excel Spreadsheets, and Microsoft PowerPoint Presentations. As long as you
make sure that these options are NOT checked when you get to this step, OpenOffice.org won't make these
changes and the Microsoft Word, Microsoft Excel, and Microsoft PowerPoint (full version or the viewer) will
remain the default for opening these files. This is documented in the Setup Guide for OpenOffice.org 2.0 on
page 26.

Installation manuals, setup guides, user guides, etc. for OpenOffice.org can be found he
http://documentation.openoffice.org/index.html

To view PDF files, you need the Adobe Acrobat Reader. You can download it he
http://www.adobe.com/products/acrobat/readstep2.html


NOTE 1: The project and software are informally referred to as "OpenOffice", but project organizers report
that this term is a trademark held by another party, requiring them to adopt "OpenOffice.org" as its formal
name (abbreviated as "OOo").

NOTE 2: OpenOffice.org is NOT developed or supported by Microsoft.




How to open a Lotus 1-2-3 spreadsheet (ending in .123) in OpenOffice.org 2.0 and convert it to a Microsoft
Excel Worksheet (.xls):


If you are on Windows 2000 or Windows XP, you WILL need to log in as an Administrator prior to installing
OpenOffice.org 2.0.

If you haven't already done so, download OpenOffice.org 2.0 from he
http://download.openoffice.org/2.0.0/index.html

Open the downloaded file and go through the installation process.

AFTER OpenOffice.org 2.0 has been installed...
Click the "Start" button (to bring up the Start Menu), point to "Programs", then point to "OpenOffice.org 2.0"
and click on "OpenOffice.org Writer".

If you are using Windows XP and don't see "Programs" under the Start Menu, look for "All Programs" instead.
In other words:
Click the "Start" button (to bring up the Start Menu), point to "All Programs", then point to "OpenOffice.org
2.0" and click on "OpenOffice.org Writer".

If this is the first time you are running OpenOffice.org, you will be given a welcome screen where you WILL
need to "Scroll Down" and "Accept" a license agreement, enter your name, etc. The last part is for
registration and is NOT required.

In OpenOffice.org Writer, click "File" and then click "Open...".

At the bottom of the "Open" dialog, you will find a selection list with the text "Files of type:" to the left
of it with "All files (*.*)" selected. Lets be a bit more specific, so click on the arrow pointing down and
choose "Lotus 1-2-3 (.wk1,*.wks,*.123)" from the list. Find your file, single click on it and click the "Open"
button.

After the file loads, click "File" and then click "Save As...".

Near the bottom of the Save As dialog box, you will find a selection list with the text "Save as type:" to the
left of it. Click on the arrow pointing down and choose "Microsoft Excel 97/2000/XP (.xls)". Choose a location
to save the file and click the "Save" button.

Now open the newly created Microsoft Excel Worksheet in Microsoft Excel as you normally would open any other
Microsoft Excel Worksheet.


I don't know how well this will convert your Lotus 1-2-3 file, but I hope it helps.




Additional notes:

Alternatively, you can open a file in OpenOffice.org by right-clicking the OpenOffice.org Quickstarter icon
(in the system tray) and choose "Open Document". The OpenOffice.org Quickstarter icon automatically loads
after OpenOffice.org has been started for the first time and will continue to load every time Windows is
started. This can be disabled in OpenOffice.org under Tools - Options... - Memory.

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"Harlan Grove" wrote in message
oups.com...
Peter Cox wrote...
Is there a Lotus viewer that allows someone usining Office to open and save
Lotus 123 files as Excel files?


It's called Lotus 123.

Flippancy aside, there used to be a 123 viewer, but it only displayed
123 files. It didn't convert them.

AFAIK, your choices are

1. Lotus 123 itself from version 9.6 on (when Lotus introed 65,536
rows),
2. Corel Quattro Pro from version 10 (WordPerfect Office 2002) on,
3. DataViz ConversionPlus,
4. ABC Amber Lotus Converter.

None are free. #2 (from auction sites) or #4 would be cheapest.

OpenOffice 2.0 and Gnumeric claim to have .123 file import filters, but
there are problems with both.



  #4   Report Post  
Timothy L
 
Posts: n/a
Default How can a file with 123 extension be opened

Look under "Featured Downloads" for "Document viewing with Verity KeyView"
http://lotus.com/products/product2.nsf/wdocs/sslibrary

The "setup32.exe" link points to the URL I replied with.

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"Timothy L" wrote in message
...
KeyView for Lotus?
ftp://ftp.lotus.com/pub/lotusweb/pro...te/kvlot32.exe



  #5   Report Post  
 
Posts: n/a
Default How can a file with 123 extension be opened


OpenOffice 2.0 and Gnumeric claim to have .123 file import filters, but
there are problems with both.


Gnumeric as-of version 1.6.0 should have a decent .123 import. 1.6.1
(whenever it gets released) will be a good deal better.

Morten

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The number 1 is appened to filename after file is opened JohnS Excel Discussion (Misc queries) 2 September 7th 05 02:56 PM
the cube file cannot be opened for writing ibot Excel Discussion (Misc queries) 0 August 4th 05 02:28 AM
pane freezes when file is opened andy b Excel Discussion (Misc queries) 3 July 4th 05 02:28 PM
.dat file extension spock Excel Discussion (Misc queries) 1 January 7th 05 09:53 PM
I need to download an exel spreadsheet file. (file extension :xls) buckrogers Excel Discussion (Misc queries) 2 December 9th 04 12:08 AM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"