Macro Sheets Only
Saves a copy of the current document using a different name but all the current document settings, such as passwords and file protection. Does not affect the current document. Use this command if you need a temporary copy of the current document; for example, to include in an electronic mail message.
Syntax
SAVE.COPY.AS(document_text)
Document_text is the name you want to give the copy of the workbook.
Example
Suppose that you are creating a macro that makes changes to a file called BUDGET95.XLS. Use the following function to save a copy of this file called TEMP.XLS without affecting BUDGET95.XLS:
SAVE.COPY.AS("temp.xls")
Related Functions
List of Command-Equivalent Functions