+ Reply to Thread
Results 1 to 2 of 2

Renaming sheet name for multiple files

  1. #1
    Registered User
    Join Date
    09-14-2022
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    8

    Post Renaming sheet name for multiple files

    Hi All,

    Is it possible to rename the worksheet name for multiple excel files in a specified folder path. Should rename all sheet names to a default value (example: ABC).
    Last edited by KarthickDijo; 06-16-2023 at 01:43 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2024
    Posts
    988

    Re: Renaming sheet name for multiple files

    Hi there,

    Yes that is possible with a macro.
    The code below will open a file picker. Select the folder, then all the files you want to rename the sheets.
    Change the sheet name from ABC to whatever default you want.

    Note: The files can only contain one sheet each as each sheet must have a unique name. If there are multiple sheets, the first one will be renamed.




    Please Login or Register  to view this content.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

+ 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. Copying and Renaming a Folder with Multiple Files
    By pecos1970 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-26-2015, 05:12 PM
  2. [SOLVED] Need help renaming multiple .pdf files
    By chazmo27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 03:11 PM
  3. Renaming of sheet name in all excel files of a directory
    By kbkrao in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2013, 01:21 AM
  4. Renaming multiple files
    By saurabh2k26 in forum Excel General
    Replies: 4
    Last Post: 12-13-2012, 03:09 AM
  5. [SOLVED] Renaming multiple files
    By rwab in forum Excel General
    Replies: 1
    Last Post: 07-30-2009, 08:19 PM
  6. Renaming multiple files in a Folder
    By csmithee in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 02:36 PM
  7. Renaming multiple files from *.csv to *.txt
    By Richard Fuller in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-19-2005, 06:06 PM

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