+ Reply to Thread
Results 1 to 2 of 2

RENAME - Multiple files - Macro or not Macro?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-08-2005
    Posts
    76

    Question RENAME - Multiple files - Macro or not Macro?

    I work with multiple files that need renaming constantly.

    Current Scenario:
    * The original file names are always varied
    * The renamed files have a specific location & specific name

    The idea is to pick to click a button, select the file - Repeat 10x (there are 10 files in 10 different locations)
    Press another button and it will rename and save all the files above in a different - single location.

    EXAMPLE
    File location: C:\TEMP\
    File name: 123456 james document1.pdf

    To be renamed, and resaved:
    NEW File location: S:\TEMP\
    File name: 123456 DOC1.pdf


    ** I have simplified the file names and locations above as in reality, it is more complicated and longer in characters.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: RENAME - Multiple files - Macro or not Macro?

    Well, excel is not the best tool for that.
    Of course if you raally want to, you can do that with Excel (Indeed. I'd suggest a macro in that case), because Excel is pretty universal one (You can move a whole shool class together with a teacher with your pick-up, but it's much easier and perceived as appropriatte approach, to use a bus for it).
    There is a range of rename_file utilities - quite a lot are freware
    And may be one of them will be "your bus". (I'm using "Bulk Rename Utility" see: http://www.bulkrenameutility.co.uk/Download.php HAve a look if it suits your needs.
    Best Regards,

    Kaper

+ 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] Macro to list files then Rename them
    By boss1982 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2014, 12:38 PM
  2. macro to rename pdf files
    By somusas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2013, 03:13 AM
  3. Rename files with a macro
    By bensalisbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2012, 07:42 AM
  4. [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
  5. Macro to rename and move files
    By Caroline25 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-15-2007, 03:11 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