Microsoft Office Tutorials and References
In Depth Information
Table 7-3. The ThisWorkbook.SaveAs Parameters
The name and path of the file to be saved.
The Excel constant representing the file format in which to save
the file. There are 44 Excel file format constants, which you can
look up in the Visual Basic Editor help system by typing
xlFileFormat in the Ask A Question box.
Sets a password for the file. The password must be 15
characters or fewer.
Sets a password for restricting who may write changes to the file,
while still allowing the file to be opened as read-only.
When set to True , displays a dialog box recommending the user
open the file in read-only mode.
When set to True , creates a backup copy of the workbook.
Indicates whether the file is saved in exclusive mode
xlExclusive ), in no changes mode ( xlNoChange ), or as a shared (
file ( xlShared ). In exclusive mode, only one user may have the
workbook open and make changes at a time. Saving a file with
no changes leaves the access mode unchanged, while saving a
file as a shared file lets more than one user have read/write
access to the file at a time.
Indicates how Excel should handle conflicting changes in a
shared workbook by setting ConflictResolution to one of these
XlSaveConflictResolution constants: xlUserResolution , the default,
which displays the Conflict Resolution dialog box;
xlLocalSessionChanges , which causes Excel to automatically
accept the local user’s changes; or xlOtherSessionChanges ,
which causes Excel to accept other changes instead of the local
user’s changes.
When set to True , adds the file name to the list of most recently
used files on the File menu.
A variant, not used in the American English version of Excel, that
controls how the characters in a workbook are interpreted and
A variant, not used in the American English version of Excel, that
controls how the workbook is displayed within the Excel
A Boolean variable that indicates whether to use the local
language set in Excel or the local language set in VBA (if
Search JabSto ::

Custom Search