Results 1 to 8 of 8

VBA to save tabs as individual workbooks by tab's name

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2014
    Location
    Atlanta, GA
    MS-Off Ver
    2010
    Posts
    5

    VBA to save tabs as individual workbooks by tab's name

    Hello,

    Every month I have to submit a report. It usually takes the whole day because there are a lot of repetitive tasks that come with preparing the report. I need is to save some of the tabs in the attached spreadsheet as their own workbook. I do not know where to even start with VBA for saving in excel.

    I would like for the new workbook to be saved as the title of the tab and into the same folder as the original file. Also, some of the tabs do not need to be saved. In the sample attachment, only tabs "20700", "40002", "10100" and "30300" need to be saved.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Breaking out tabs of a workbook and keeping the links into individual workbooks
    By ozne99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2012, 03:02 PM
  2. [SOLVED] Save All Worksheets As Individual Workbooks In a Special Folder in PDF format
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-20-2012, 01:27 PM
  3. Replies: 3
    Last Post: 10-03-2010, 11:07 PM
  4. individual tabs for subtotaled data
    By Scott in forum Excel General
    Replies: 3
    Last Post: 07-30-2006, 11:00 AM
  5. Protect Individual Tabs Uniquely
    By rshirk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-21-2005, 08:36 AM

Tags for this Thread

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