Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/101940

From BetaArchive Wiki

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

The information in this article applies to:

  • Microsoft Excel for Windows, version 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.


"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

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

Keywords :
Version : 4.00a 5.00
Platform : WINDOWS
Issue type :
Technology :

Last Reviewed: April 5, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.