A
Akshay Bakhai
Here is a quick and dirty solution, but one that will work.
Let's assume that column A contains old file names and
column B contains new file names.
So, A2 will have DSCN1234 and so on.
Let us also assume that the worksheet on which this data
is present is called SHEET1.
Now on a different sheet, select a cell, say A2.
Therein, type the formula = CONCATENATE ("rename ", Sheet1!
A2, " ", Sheet1!B2).
Copy this formula down to as many rows as you have on
Sheet1.
Thereafter, save the spreadsheet file as a TXT file in the
folder c:\images. Save the file with an extension of .bat
Thereafter go into command prompt and into the folder
c:\images. From this folder execute the previously
saved .bat file.
as I mentioned, it is a dirty solution, but it is a quick
and workable solution.
Let's assume that column A contains old file names and
column B contains new file names.
So, A2 will have DSCN1234 and so on.
Let us also assume that the worksheet on which this data
is present is called SHEET1.
Now on a different sheet, select a cell, say A2.
Therein, type the formula = CONCATENATE ("rename ", Sheet1!
A2, " ", Sheet1!B2).
Copy this formula down to as many rows as you have on
Sheet1.
Thereafter, save the spreadsheet file as a TXT file in the
folder c:\images. Save the file with an extension of .bat
Thereafter go into command prompt and into the folder
c:\images. From this folder execute the previously
saved .bat file.
as I mentioned, it is a dirty solution, but it is a quick
and workable solution.