antp.be forum

Hi Antoine,

I'm using your great renamer-tool for many years, but now I have a Problem I cannot solve with it.
I want to rename excel-files with log-data in it. The original file-names are generated automatical with more or less random file name.
I need to rename the files by using the date of logging. Actual I rename them manually in syntax "yyyymmdd.xls".
I want to automate this by using the date information in the excel-log itself. In cell A4 there is the date auf logging in the syntax "dd.mm.yyyy hh:mm:ss".
Is there a way to use this Information to rename it?

Kind regards,
Christop

Hi,
If you can generate a list of the new names in the same order as Ant Renamer lists them, using the action "From file" allows you to do that (you can copy/paste your list of file names from Excel to a text file or directly to Ant Renamer).
If however you need the link between existing file name and new file name, as the order is not fixed, then you can't do it with Ant Renamer, but you could generate a batch file directly with Excel.
For that, add/hide the required columns to obtain the following line:
ren sourcefile.xls targetfile.xls
So when you have your three columns, one with just "ren", you can copy/paste to a text file, replace tabs by spaces (as by default Excel puts tabs between columns), and save that with a .bat or .cmd extension in the folder where the Excel files are, and run it.