Save As Values
- You are prompted for a new file name with the default being the current file name plus the word "Values" in parenthesis.
- All queries based on the Event 1 data source are removed, but the data remains on the spreadsheet.
- All Office Connector workbook functions are replaced by their values.
- The workbook is saved under the new name.
Unattended AutomationThe Save As Values command can be recorded and called from a VBA macro; just like when invoked from the toolbar, the recorded macro uses the Save As dialog to prompt for the new file name. It is possible to suppress the Save As dialog box by editing your macro to pass a file name to the OCSaveAsValues command.
|Note -||You must make sure that the file does not already exist or Excel will prompt to replace the existing file. Also, for users of Excel 2007 and above, you must choose an appropriate file extension to avoid additional confirmation prompts (for example, using the XLAM file extension because your workbook contains macros).|