Excel: Additional Arguments for SAVE.AS() in Version 4.0a

 Last reviewed: September 12, 1996
Article ID: Q101940

The information in this article applies to:

  • Microsoft Excel for Windows, versions 4.0a, 5.0

In Microsoft Excel versions 4.0a and 5.0, there is additional support for importing and exporting Lotus 1-2-3 Allways-formatted files. In Microsoft Excel for Windows version 4.0a, the SAVE.AS() function will accept the additional arguments of 30, 31, and 32 for the type_num argument.

Although page 369 of the "Function Reference," version 4.0, only lists 29 file formats, Microsoft Excel version 4.0a, includes the following three additional arguments for Lotus 1-2-3 file formats: 

   Type_num         File format
   ----------------------------

   30                WK1,FMT
   31                WK1,ALL
   32                WK3,FM3
When you use type_num 30, the spreadsheet will be saved with the .WK1 filename extension and it will also be saved in a format file with the filename as the spreadsheet but with the .FMT filename extension. When you use type_num 31, the file will be saved as a spreadsheet with the .WK1 filename extension and a format file with an .ALL filename extension. When you specify a type_num of 32, the spreadsheet will be saved with a .WK3 filename extension and a format file with a .FM3 extension.

REFERENCES

"Function Reference," version 4.0, page 369 "User's Guide," version 4.0, pages 60, 61 "Switching to Microsoft Excel from Lotus 1-2-3," version 4.0, pages 26-27

KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 5.00 4.00a Impress formatting 123 convert macro



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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.