Saves a copy of the current document using a different name but all the current document settings, such as passwords and file protection
static int SaveCopyAs( LPCTSTR document_text );
Document_text is the name you want to give the copy of the workbook.
Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.
See the Microsoft Excel on-line Help for full details about this function.