SAVE.COPY.AS macro

Saves a copy of the current workbook using a different name but all the current workbook settings, such as passwords and file protection. Does not affect the current workbook. Use this command if you need a temporary copy of the current workbook; 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")

Return to index