SAVE.AS

Macro Sheets Only

Equivalent to choosing the Save As command from the File menu. Use SAVE.AS to specify a new filename, file type, protection password, or write-reservation password, or to create a backup file.

Syntax

SAVE.AS(document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec)

SAVE.AS?(document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec)

Document_text specifies the name of a workbook to save, such as SALES.XLS (in Microsoft Excel for Windows) or SALES (in Microsoft Excel for the Macintosh). You can include a full path in document_text, such as C:\EXCEL\ANALYZE.XLS (in Microsoft Excel for Windows) or HARDDISK:FINANCIALS:ANALYZE (in Microsoft Excel for the Macintosh).

Type_num is a number specifying the file format in which to save the workbook.

Type_num File format

1 or omitted Normal

2 SYLK

3 Text

4 WKS

5 WK1

6 CSV

7 DBF2

8 DBF3

9 DIF

10 Reserved

11 DBF4

12 Reserved

13 Reserved

14 Reserved

15 WK3

16 Microsoft Excel 2.x

17 Template

18 Add-in macro (For compatibility only. In Microsoft Excel 5.0, this saves as normal.)

19 Text (Macintosh)

20 Text (Windows)

21 Text (MS-DOS)

22 CSV (Macintosh)

23 CSV (Windows)

24 CSV (MS-DOS)

25 International macro

26 International add-in macro

27 Reserved

28 Reserved

29 Microsoft Excel 3.0

30 WK1 / FMT

31 WK1 / Allways

32 WK3 / FM3

33 Microsoft Excel 4.0

34 WQ1

35 Microsoft Excel 4.0 workbook

36 Formatted text (space delimited)

The following table shows which values of type_num apply to the six Microsoft Excel document types.

Document Type Type_num

Worksheet All except 10, 12-14, 18, 25-28, 36

Chart sheet All except 10, 12-14, 18, 25-28

Visual Basic module 1, 3, 17

Dialog 1, 17

Macro sheet 1-3, 6, 9, 16-29, 33

Workbook 1, 15, 35

Prot_pwd corresponds to the Protection Password box in the Save Options dialog box.

• Prot_pwd is a password given as text or as a reference to a cell containing text. Prot_pwd should be no more than 15 characters.
• If a file is saved with a password, the password must be supplied for the file to be opened.

Backup is a logical value corresponding to the Always Create Backup File check box in the Save Options dialog box and specifies whether to make a backup workbook. If backup is TRUE, Microsoft Excel creates a backup file; if FALSE, no backup file is created; if omitted, the status is unchanged.

Write_res_pwd corresponds to the Write Reservation Password box in the Save Options dialog box and allows the user to write to a file. If a file is saved with a password and the password is not supplied when the file is opened, the file is opened read-only.

Read_only_rec is a logical value corresponding to the Read-Only Recommended check box in the Save Options dialog box.

• If read_only_rec is TRUE, Microsoft Excel saves the workbook as a read-only recommended workbook; if FALSE, Microsoft Excel saves the workbook normally; if omitted, Microsoft Excel uses the current settings.
• When you open a workbook that was saved as read-only recommended, Microsoft Excel displays a message recommending that you open the workbook as read-only.

Related Functions

CLOSE Closes the active window

GET.DOCUMENT Returns information about a workbook

SAVE Saves the active workbook

SAVE.WORKBOOK Saves a workbook

List of Command-Equivalent Functions