+ Reply to Thread
Results 1 to 5 of 5

Macro to save a single worksheet from a multiple sheet workbook

  1. 04-23-2018, 09:13 PM #1
    tfilipe
    tfilipe is offline
    Registered User
    Join Date
    03-29-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2013
    Posts
    73

    Macro to save a single worksheet from a multiple sheet workbook

    Good evening people,

    Not sure if my request is possible I would like to save only one sheet from a multiple sheet workbook.

    If so, anyone willing to share the procedure please?

    Kind Regards
    Tony
    Reply With QuoteRegister To Reply
  2. 04-23-2018, 09:35 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro to save a single worksheet from a multiple sheet workbook

    something like...

    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-24-2018, 03:21 PM #3
    tfilipe
    tfilipe is offline
    Registered User
    Join Date
    03-29-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Macro to save a single worksheet from a multiple sheet workbook

    Thank you humding,

    It's generating a runtime error....!
    Reply With QuoteRegister To Reply
  4. 04-24-2018, 09:30 PM #4
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro to save a single worksheet from a multiple sheet workbook

    "C:\MyFolder\MySubFolder\Test.xls"
    replace the destination with your folder / file name
    Reply With QuoteRegister To Reply
  5. 04-25-2018, 08:01 PM #5
    tfilipe
    tfilipe is offline
    Registered User
    Join Date
    03-29-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Macro to save a single worksheet from a multiple sheet workbook

    It still generates the error!

    This worked, I do I get it to save only rows 4 to 123?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save a single worksheet from a workbook as a separate read only workbook
    By jmking1999 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2017, 09:49 AM
  2. Macro to extract initials and project from a multiple worksheet into a single sheet.
    By yrkoski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 03:47 PM
  3. Save Single Sheet from multiple sheet workbook as MSDOS CSV format
    By BBen in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2012, 08:34 AM
  4. Macro Copy/Save active worksheet into a pre-existing workbook & rename sheet to cell data
    By richl4858 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2012, 06:06 PM
  5. How can I save a single sheet of a workbook using a macro
    By prouddad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2009, 03:02 AM
  6. how do i save a single sheet from my workbook?
    By eyesonly1965 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2006, 03:35 PM
  7. [SOLVED] Save a single sheet from a workbook
    By JAMES T. in forum Excel General
    Replies: 3
    Last Post: 01-25-2005, 11:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1