Name
workbook.SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
Synopsis
Saves the workbook and sets the workbook’s file properties.
|
Argument |
Settings |
|---|---|
|
|
The name of the file to save. Default is current filename. |
|
|
One of the following |
|
|
A password the user must enter to open the file. |
|
|
A password the user must enter to open the file for read/write access. |
|
|
True causes Excel to display a dialog box recommending the file be opened for read-only access when the user opens the file; False does not display the dialog box. Default is False. |
|
|
True creates a backup version of the file when the file is saved; False does not create a backup. Default is False. |
|
|
One of the following |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access