SaveCopyAs(Object) Will save a duplicate with the workbook to a file but does not modify the open up workbook in memory.From Microsoft: Using the new capabilities in Excel, You will be telling your facts's story very quickly. Charts, graphs, keyboard shortcuts and information entry enhancements (like components builder and autocomplete) immediately