Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

Renamer application using Excel

- - - - -

  • Please log in to reply
6 replies to this topic

#1
Furiusd

Furiusd
  • Member
  • 2 posts
  • Joined 26-April 07
Hello

I'm looking for some software that can batch process a big list of files. I've got two columns in Excel, one with the old names and one with the new ones. Does anyone know of an application which can read excel, find the corresponding file in a subdirectory and rename it to the new name? The files are not in much of an order so can't just export a text file.

Thanks


How to remove advertisement from MSFN

#2
jondercik

jondercik

    Advanced Member

  • Member
  • PipPipPip
  • 443 posts
  • Joined 15-January 04
vbscript can read excel files
Jim
R.I.P. Alienware
1996-2006

#3
IcemanND

IcemanND

    MSFN Junkie

  • Super Moderator
  • 3,252 posts
  • Joined 24-September 03
  • OS:Windows 8.1 x64
  • Country: Country Flag
Here are two topics to get you started:
First renaming folders using data in an excel spreadsheet:
http://www.microsoft...06/hey1030.mspx

Second renaming files using data in a text doc:
http://www.microsoft...06/hey0511.mspx

#4
jcarle

jcarle

    MSFN Master

  • Developer
  • 2,559 posts
  • Joined 14-August 04
It never ceases to amaze me the new approaches people come up with to solve a problem.
Posted Image
Posted Image

#5
Furiusd

Furiusd
  • Member
  • 2 posts
  • Joined 26-April 07
ah. Thanks, but I'm terrible at coding. Plus I don't really have the time at work to learn (not gonna do it in my spare time!). Anyone know of any pre-made applications which can do it?

Thanks again

#6
nmX.Memnoch

nmX.Memnoch

    MSFN Master

  • Patrons
  • 2,084 posts
  • Joined 15-September 04
  • OS:Windows 7 x64
  • Country: Country Flag

not gonna do it in my spare time!


But you expect one of us to do it in our spare time so you can save yours? I like to help people...but you have to be willing to do at least part of the work! :)

IcemandND pointed you to a couple of articles that will do everything you want...all you have to do is a little copy and pasting with some minor editing.

#7
Guest_tempokura_*

Guest_tempokura_*
  • Guests
  • Joined --
ReNamer from den4b.com can do it!

Just save your Excel files as *.txt (tab separated) or *.csv (comma separated).
Then use "Import list of files and new names" from the Options menu in ReNamer.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users