+ Reply to Thread
Results 1 to 5 of 5

VBA: Rename files using Excel - OldName / NewName

Hybrid View

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    Cambridge
    MS-Off Ver
    365 for Mac
    Posts
    4

    VBA: Rename files using Excel - OldName / NewName

    Hi

    I have around 3000 images in a folder I need to rename.
    I have a list of all the current images names in excel and have created a column next to them with the names I need them to be.

    I understand I can use this to change the file names in the folder

    I'm not super techy so assume it has to be a simple as possible, please
    Last edited by AliGW; 10-02-2021 at 09:33 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,473

    Re: Rename files using Excel - OldName / NewName

    Change within Excel? Or something else?

    I am really not clear what you are asking.

    By the way, you never responded to the help I offered last time you were here.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-25-2019
    Location
    Cambridge
    MS-Off Ver
    365 for Mac
    Posts
    4

    Re: Rename files using Excel - OldName / NewName

    Just edited the post.

    Apologies, I didn't realise your answer to my previous post needed a reply and I assumed as you edited it saying oops just seen I am on a mac that what you were proposing only works with Windows?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,473

    Re: Rename files using Excel - OldName / NewName

    Why would you NOT reply to someone offering help? What a strange thing to say. I would always thank anyone - maybe that's just me.

    You will need VBA to do what you want. I will move this to the VBA section where one of our VBA experts will take a look.

    If you are still using a Mac, then your forum profile should say 365 for Mac. Please update this. Thanks.

  5. #5
    Registered User
    Join Date
    07-25-2019
    Location
    Cambridge
    MS-Off Ver
    365 for Mac
    Posts
    4

    Re: VBA: Rename files using Excel - OldName / NewName

    Great

    Thanks for all your help

+ 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. Ability to rename multiple files from a path and move and rename to another.
    By X82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2020, 09:54 PM
  2. Rename Multiple PDF Files using Excel VBA
    By swithinmurickal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2018, 01:21 PM
  3. My File Rename Macro Always Doesn't Rename the Last Three files in the list
    By Enright in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2016, 03:46 PM
  4. Rename Excel Files in A folder
    By pradeepjassal in forum Excel General
    Replies: 1
    Last Post: 09-11-2012, 03:23 PM
  5. Excel to move and rename files
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 07:01 PM
  6. [SOLVED] Rename files with excel macro.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2010, 11:49 AM
  7. Rename Files according to Excel
    By nima in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2006, 10:10 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