+ Reply to Thread
Results 1 to 3 of 3

rename files in a folder with foldername

  1. #1
    Forum Contributor
    Join Date
    04-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    193

    rename files in a folder with foldername

    when i select a folder then i need to change all the .jpg files in a particular criteria
    eg;
    path=E:/Myfolder/KL21B/
    file names are
    2sdfs35.jpg
    1.jpg
    sder3.jpg
    35sder4.jpg

    for these file rename as

    KL21B-A = 1.jpg
    KL21B-B = 2sdfs35.jpg
    KL21B-C = sder3.jpg
    KL21B-D = 35sder4.jpg

    continue sequencies(A,B,C,D,E,F,G,H.......)

    rememberable thing is 1.jpg must be the first picture (KL21B-A).

    can i create a macro for that??

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: rename files in a folder with foldername

    How are you sorting the pictures? why is sder3 between 2sdfs35 and 35sder4?

  3. #3
    Forum Contributor
    Join Date
    04-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    193

    Re: rename files in a folder with foldername

    Thank you Mr.Yudlugar

    i did not sort the file names if need we can sort but the 1.jpg must be (Foldername)-A picture

    but we should be care if a image having the name 0E53S (starting from zero).
    currently i am using this code

    Also when we extract file name to excel it will be as assending order.

    i am not a programmer so if any change pls inform
    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)

Similar Threads

  1. Rename .pdf files in a folder
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-11-2019, 01:11 AM
  2. [SOLVED] Rename Files in A folder
    By pradeepjassal in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2012, 10:36 AM
  3. [SOLVED] rename files in a folder
    By Varun Nair in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2006, 08:25 AM
  4. [SOLVED] rename files in a folder
    By Varun Nair in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2006, 05:05 AM
  5. [SOLVED] rename all files in a folder
    By DIBS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2006, 02:50 AM

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