+ Reply to Thread
Results 1 to 2 of 2

Move sheet to its own workbook and save

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    20

    Move sheet to its own workbook and save

    Hello,

    I'm need a macro to do the following upon hitting a command button on the sheet:

    1) Move the sheet to a new workbook, but do not carry over macro button or code
    2) Save the new workbook as the name of the sheet (Example: if sheet name was "Sheet1", then new workbook would be saved as "Sheet1.xls") to C:\Folder1
    3) Close the new workbook after it's been saved

    I would also like a macro that will do the same thing as mentioned above, but instead of using the sheet name as the save as name, I would like the macro to save the new workbook as the sheet name and todays date + 1. Example: If the sheet was named "Schedule" and today was 8/22/2012, I would like it to save the new workbook as "Schedule 082312.xls".

    Thanks for your help!
    Last edited by Kholmes11; 08-23-2012 at 10:00 AM.

  2. #2
    Registered User
    Join Date
    08-09-2012
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    20

    Re: Move sheet to its own workbook and save

    Can anyone help??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1