+ Reply to Thread
Results 1 to 3 of 3

Change files names based on cell value

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Change files names based on cell value

    Hello,

    I have hundreds of files in the same file path and I need to mass update the file name. I can create a spreadsheet of two columns, "Current Name" and "New name".
    Is there a way to have excel do this for me?

    Thank you,

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Change files names based on cell value

    try the code in the post #1 https://www.excelforum.com/excel-pro...haracters.html

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Change files names based on cell value

    Assumes headers in top row, old file name in Column A, new file name in Column B
    Columns A & B have file names without path but with file extensions
    Change references as required.

    Please Login or Register  to view this content.
    Do you want code to output all the existing file names in the folder to Column A?
    And what about the new names?


    This might be interesting.
    https://www.publicspace.net/windows/BetterFileRename/
    Last edited by jolivanes; 03-20-2023 at 01:13 AM.
    Experience trumps academics every day of the week and twice on Sunday.

+ 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. [SOLVED] Change all file names in folder based on cell values
    By bartolos in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-11-2022, 10:38 AM
  2. Replies: 4
    Last Post: 07-24-2019, 01:41 AM
  3. [SOLVED] Dynamically change multiple sheet names based upon a cell's value
    By Murman01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2018, 12:01 PM
  4. [SOLVED] Automatically change sheet (tab) names based on cell on sheet1
    By PitBoo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2017, 03:46 PM
  5. change cell names based on new sheet name
    By tdebb8594 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2014, 02:25 PM
  6. [SOLVED] How to Split Excel Spreadsheets into new .xls files based on their cell names?
    By Ardiko in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-02-2013, 02:22 PM
  7. Two Linked Files But I Change Files Names Each Job
    By barrha0b in forum Excel General
    Replies: 3
    Last Post: 08-30-2013, 11:08 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