Hi Everyone,
Is it possible to write a macro that will save the current worksheet I am working on as a NEW tab on an existing file? ie, Clicking on a run macro button will bring up the "save as" screen, allowing the user to pick the file into which he/she wants to save the current workbook. Then, it will automatically create a new worksheet in that file, copy the data in the open workbook to that worksheet, save, and then close. (This will also take off all macros since only the data in the spreadsheet will be copied.) Thanks in advance!
Is it possible to write a macro that will save the current worksheet I am working on as a NEW tab on an existing file? ie, Clicking on a run macro button will bring up the "save as" screen, allowing the user to pick the file into which he/she wants to save the current workbook. Then, it will automatically create a new worksheet in that file, copy the data in the open workbook to that worksheet, save, and then close. (This will also take off all macros since only the data in the spreadsheet will be copied.) Thanks in advance!