+ Reply to Thread
Results 1 to 3 of 3

Change specific sheet name of folder & Sub folders

  1. #1
    Forum Contributor
    Join Date
    12-03-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    153

    Change specific sheet name of folder & Sub folders

    Hi,
    I am hereby attaching SAMPLE file in which I have specified
    Column A : File names
    Column B : Original name of specific sheet
    Column C : New Name of sheet

    I want to change specific sheet i.e. having in a folder or sub folder having name prescribed in column B of attached file must be change as mentioned in Column C
    I have used following code to extract all sheet names of folder & sub folder in file & extract only those names which have to be get changed

    The data I have is very large so if solution provided save my time & efforts.

    Thanks in advance.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-03-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    153

    Re: Change specific sheet name of folder & Sub folders

    Hi,
    I have got this code on some other site to delete the sheet which is having same sheet name in different files & folder.

    Help require to modify it which can be rename the sheets to 'GROCERY' as I have mentioned in the list in file
    Sheet Name change vba. xls



    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    12-03-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    153

    Re: Change specific sheet name of folder & Sub folders

    Hi,
    I have used following code & got perfect result

    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)

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