WE1130: Lotus 1-2-3 WK4 File Converter

Last reviewed: October 7, 1997
Article ID: Q122583

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0a, 5.0c

The "Lotus 1-2-3 WK4 File Converter" (WE1130) Application Note is now available from Microsoft Product Support Services (PSS). The WE1130 disk that accompanies this Application Note includes a converter that you can use to open WK4 files in Microsoft Excel versions 5.0, 5.0a, and 5.0c.

You can obtain this Application Note from the following sources:

Microsoft's World Wide Web Site on the Internet
The Internet (Microsoft anonymous ftp server)
Microsoft Download Service (MSDL)
Microsoft FastTips Technical Library
Microsoft Technical Support

For complete information, see the "To Obtain This Application Note" section at the end of this article.

THE TEXT OF WE1130

  Microsoft(R) Product Support Services Application Note (Text File)
             WE1130: LOTUS(R) 1-2-3(R) WK4 FILE CONVERTER

                                                  Revision Date: 12/94
                                                                1 Disk

The following information applies to Microsoft Excel for Windows(TM), version 5.0, 5.0a, 5.0c.

 ---------------------------------------------------------------------
| INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY     |
| ACCOMPANY THIS DOCUMENT (collectively referred to as an Application |
| Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER      |
| EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED      |
| WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR       |
| PURPOSE. The user assumes the entire risk as to the accuracy and    |
| the use of this Application Note. This Application Note may be      |
| copied and distributed subject to the following conditions: 1) All  |
| text must be copied without modification and all pages must be      |
| included;  2) If software is included, all files on the disk(s)     |
| must be copied without modification (the MS-DOS(R)  utility         |
| diskcopy is appropriate for this purpose);  3) All components of    |
| this Application Note must be distributed together;  and  4) This   |
| Application Note may not be distributed for profit.                 |
|                                                                     |
| Copyright (C) 1994 Microsoft Corporation.  All Rights Reserved.     |
| Microsoft and MS-DOS are registered trademarks and Windows and      |
| Windows NT are trademarks of Microsoft Corporation.  Lotus and      |
| 1-2-3 are registered trademarks of Lotus Development Corporation.   |
 ----------------------------------------------------------------------

Introduction

The WE1130 disk included with this Application Note contains a Lotus 1-2-3 WK4 file converter for use with Microsoft Excel versions 5.0, 5.0a, and 5.0c for Windows. This converter allows you to convert your existing Lotus 1-2-3 Release 4 or 5 for Windows files to Microsoft Excel 5.0 files.

Microsoft Excel 5.0 for Windows shipped without the ability to open or save files in WK4 format. The file converter provided with this Application Note allows you to use Microsoft Excel version 5.0, 5.0a, or 5.0c to open WK4 files. This file converter does not provide the functionality to save a file in Microsoft Excel to the WK4 file format.

  NOTE: The Lotus 1-2-3 WK4 file converter does not work with
  Microsoft Excel for Windows NT(TM).

To install the Lotus 1-2-3 WK4 converter

  NOTE: If you are running Microsoft Excel from a protected network
  server drive or if you want to install the converter to a location
  other than the Microsoft Excel directory, see the "Alternative
  Installation Method" section of this Application Note.

Quit Microsoft Excel for Windows.

If you received this Application Note on a disk, insert the enclosed WE1130 disk in your floppy disk drive.

In Windows Program Manager, choose Run from the File menu.

In the Command Line box, type <location>:\setup.exe and press ENTER (where <location> is the floppy disk drive that contains the WE1130 disk or, if you received this Application Note electronically, the disk or directory to which you downloaded the file). For example, if the disk is in drive A, type

      a:\setup.exe

or, if the downloaded Application Note is in the directory C:\DNLOADS, type:

      c:\dnloads\setup.exe

When the Setup program is finished, a dialog box will appear, confirming that the WK4 file converter has been installed.

  NOTE: For information about installing the Lotus 1-2-3 WK4 file
  converter from a directory on a network drive, and for more
  information about using the file converter, see the README.TXT file
  on the enclosed WE1130 disk or in the location to which you
  downloaded this Application Note.

When you run the Setup program, it copies the XLCONVW4.DLL file to your Microsoft Excel directory. The rest of the files included on the WE1130 disk are used to run the Setup program.

When you run the Setup program, if you receive an error message stating that Setup tried to create an invalid path or that Setup cannot find Microsoft Excel, use the method described in the "Alternative Installation Method" section on page page 2 of this Application Note to install the converter to a location other than the Microsoft Excel directory.

To use the Lotus 1-2-3 WK4 file converter

After you install this converter, do the following to open your existing Lotus 1-2-3 Release 4 or 5 files in Microsoft Excel:

In Microsoft Excel, choose Open from the File menu.
From the List Files Of Type list, select Lotus 1-2-3 Release 4 or 5 (*.WK4).
From the File Name list, select the file that you want to open, and choose OK.

Alternative Installation Method

Use this method if you are running Microsoft Excel from a protected network server drive or if you want to install the converter to a location other than the Microsoft Excel directory.

Quit Microsoft Excel for Windows.
If you received this Application Note on a disk, insert the enclosed WE1130 disk in the appropriate floppy disk drive.
In Windows Program Manager, choose Run from the File menu.
In the Command Line box, type <location>:\wk4iniup.exe and press ENTER (where <location> is the floppy disk drive that contains the WE1130 disk or, if you received this Application Note electronically, the disk or directory to which you downloaded the file). For example, if the disk is in drive A, type
```
      a:\wk4iniup.exe
```
or, if the downloaded Application Note is in the directory C:\DNLOADS, type:
```
      c:\dnloads\wk4iniup.exe
```
The WK4 Converter Excel5.INI Updater dialog box will appear.
In the Install DLL To box, enter the name of directory in which you want to install the converter, such as C:\WINDOWS\SYSTEM.
```
      Note that the location that you enter in the Install DLL To box
      must be an existing directory.
```
Choose the Install XLCONVW4.DLL button.
If you have already installed the converter, a dialog box will appear telling you that the converter is already listed in your EXCEL5.INI file. This dialog box will display both the current path and the new path that you entered, and it will ask if you still want to update this information.
Choose Yes to install the converter to the new location.
If you enter an incorrect path, or if there is not enough disk space on the drive, the following error message will appear:
```
      Can't Write File
```
```
      The file XLCONVW4.DLL could not be written because there is not
      enough space to write destination file, the destination path is
      not valid, or the destination is protected. Please verify
      destination path.
```
To correct this problem, you must either free up some disk space on the drive to which you are installing the converter or enter another location for the converter.

When the Updater program is finished, a dialog box will appear, confirming that your EXCEL5.INI file has been updated with the converter information. This dialog box will also tell you the converter number of the added Lotus 1-2-3 WK4 converter.

  NOTE: For information about installing the Lotus 1-2-3 WK4 file
  converter from a directory on a network drive, and for more
  information about using the file converter, see the README.TXT file
  on the enclosed WE1130 disk or in the location to which you
  downloaded this Application Note.

When you run the Updater program, it copies the XLCONVW4.DLL file to the location that you entered in the Install DLL To box. The rest of the files in the DISK1 directory are used to run the Setup program.

TO OBTAIN THIS APPLICATION NOTE

The following file(s) are available for download from the Microsoft Software Library:

 ~ WE1130.EXE (size: 489009 bytes)

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

If you are unable to access the source(s) listed above, you can have this Application Note mailed to you by calling Microsoft Product Support Services Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time at (425) 635-7070. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, see the Microsoft World Wide Offices Web site at:

   http://www.microsoft.com/worldwide/default.htm

Additional query words: 5.00 5.00c appnote
Keywords : kb3rdparty kbappnote kbfile
Version : 5.00 5.00c
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 7, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.