+ Reply to Thread
Results 1 to 9 of 9

Export worksheets with number as name

  1. #1
    Registered User
    Join Date
    09-04-2021
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Export worksheets with number as name

    Hi, I have a workbook with 10 sheets and need to export 3 worksheets with numbers as name "1", "2" and "3" in separate workbooks.

    Please Login or Register  to view this content.
    Thought about to incorporate the code below. Worksheets names are numbers: "1","2" and "3"
    Please Login or Register  to view this content.

    Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Export worksheets with number as name

    Give it a try
    Please Login or Register  to view this content.
    Messages have been translated from Dutch to English by means of google translate.

  3. #3
    Registered User
    Join Date
    09-04-2021
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Re: Export worksheets with number as name

    Thanks, its working.

    Is there still the option to use this code below? What do I need to add here that only the sheets with numbers are copied?

    Please Login or Register  to view this content.
    Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Export worksheets with number as name

    The question is not really clear. Do you now only want to save sheets containing 1, 2 and 3? Or all sheets that contain a number?
    2 options and otherwise just post a file.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-04-2021
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Re: Export worksheets with number as name

    Basically all sheets that contain a number. Works perfectly. Thank you!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Export worksheets with number as name

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    09-04-2021
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Re: Export worksheets with number as name

    How to include this part that the files have the same name as the workbook into the code below?
    Please Login or Register  to view this content.
    Quote Originally Posted by Vraag en antwoord View Post
    The question is not really clear. Do you now only want to save sheets containing 1, 2 and 3? Or all sheets that contain a number?
    2 options and otherwise just post a file.
    Please Login or Register  to view this content.
    Thank you!

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Export worksheets with number as name

    If you still want help, then remove the solved tag for now.

  9. #9
    Registered User
    Join Date
    09-04-2021
    Location
    London, England
    MS-Off Ver
    365
    Posts
    18

    Re: Export worksheets with number as name

    Hi all,

    I want with this code loop through 7 different chechboxes and if checked run code below, but not on every numeric worksheet name, only on those which are checked.

    Thank you!


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Export worksheets to new file VBA to 'Break Links' on export?
    By Spoonman667 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-18-2021, 03:13 AM
  2. [SOLVED] Export Worksheets
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2014, 04:15 AM
  3. Export Specified Worksheets
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-19-2014, 01:45 PM
  4. [SOLVED] Export Specified Worksheets to PDF
    By dmarzean in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2014, 03:30 AM
  5. Replies: 1
    Last Post: 10-30-2012, 06:34 PM
  6. Export worksheets
    By mjhopler in forum Excel General
    Replies: 2
    Last Post: 06-14-2010, 01:02 PM
  7. XML Export and worksheets
    By WHoit in forum Excel General
    Replies: 0
    Last Post: 03-15-2005, 07:06 PM

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