Excel: Importing a Quattro Pro or Symphony File
PSS ID Number: Q104237
Article last modified on 10-26-1993
PSS database name: W_eXceL

2.X 3.00 4.00 4.00a | 2.20 2.21 3.00 | 2.X 3.00 4.00

WINDOWS             | OS/2           | MACINTOSH


----------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, and 4.0a
 - Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, and 4.0
 - Microsoft Excel for OS/2, versions 2.2 and 3.0
----------------------------------------------------------------------

SUMMARY
=======

In Microsoft Excel, you cannot directly import a Quattro Pro
spreadsheet if it is in the .WQ1 file format or a Symphony file if it
is in the .WR1 file format.

To open these files in Microsoft Excel, you must first save them in in
Lotus 1-2-3 .WK1 or .WKS file format.

MORE INFORMATION
================

Saving Your File
----------------

To save a Quattro Pro file in the .WK1 or .WKS file format:

1. In Quattro Pro, open the file you want to be able to open in
   Microsoft Excel.

2. From the File menu, choose Save As.

3. Type the name of your file and use either the .WK1 or .WKS filename
   extension (you can also save the file in the .SLK or .DBF format).

To save a Lotus Symphony file in the .WK1 or .WKS file format:

1. In Lotus 1-2-3, open the file you want to be able to open in
   Microsoft Excel.

2. Press the F9 key to recalculate the worksheet.

3. Choose File Save.

4. Type the full pathname of the directory you want to save to
   followed by the filename and the .WK1 or .WKS filename extension.

Opening the .WK1 or .WKS File in Microsoft Excel
------------------------------------------------

To open the newly saved file in Microsoft Excel:

1. From the File menu, choose Open.

2. Change to the directory containing the file you want to open.

3. In the File Name box, type "*.wk*" (without the quotation marks),
   or choose Lotus 1-2-3 from the List Files Of Type Box, to locate
   your file.

4. Select the file from the File Name box and choose the OK button.

REFERENCES
==========

"User's Guide 2," version 4.0, pages 147-152
"User's Guide," version 3.0, pages 56-61
"Function Reference Guide," version 2.10, pages 484-485
"Quattro Pro Users Guide," version 3.0, pages 253-256
Quattro Pro Help, "Retrieving and Saving 1-2-3 Files"

Additional reference words: 2.x 3.00 4.00 4.00a mpf Borland worksheets
export translate 123

Copyright Microsoft Corporation 1993.