| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 27332 | 2002-11-20 06:07:00 | Excel and renaming files | Mike (15) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 99790 | 2002-11-20 06:07:00 | I have a spreadsheet at work with a column of file names (around 400 of them) and a column next to that column with what the file names should be changed to. Is there any way to automate the process so that I don't have to rename each file manually one-by-one? :D I'm lazy. Mike. |
Mike (15) | ||
| 99791 | 2002-11-20 06:09:00 | I suppose I should give more info :) Excel 2002 Win 2000 pro (I think) on a network (I doubt this will have any impact on anything) The files are currently named something like "SA 23874" and they will be changed to something like "102145". File extension is to remain the same (.tif). Any ideas? mike. |
Mike (15) | ||
| 99792 | 2002-11-20 07:30:00 | Someone may think of an automatic way but in case they don't... In Windows Explorer use the F2 key to rename rather than mouse clicks. You could have the Excel and Explorer windows open together side by side and copy, F2, paste. |
Heather P (163) | ||
| 99793 | 2002-11-20 07:51:00 | > Someone may think of an automatic way but in case > they don't... > > In Windows Explorer use the F2 key to rename rather > than mouse clicks. > > You could have the Excel and Explorer windows open > together side by side and copy, F2, paste. Thanks Heather - that's what I've been doing... but when there's columns of similar looking numbers, its a very difficult method to follow :) I'm hoping for the automatic way :D Mike. |
Mike (15) | ||
| 99794 | 2002-11-20 08:16:00 | If you have a certain rule you can apply, like replace "A" with "1" etc then this freeware tool can do it for you. www.1-4a.com Freeware too. :-) |
Elephant (599) | ||
| 99795 | 2002-11-20 08:31:00 | Old name column A, new name column B, formula column C reads: ="REN "&A1&" "&B1 Note spaces after REN and in " ". Copy down, then copy results and paste as values in a sheet, save as text file called newames.bat. At the Dos command prompt get into the directory and type newnames.bat and press <enter> Assuming everything is in one directory. Or am I missing something and being an utter twat? robo. |
robo (205) | ||
| 99796 | 2002-11-20 08:54:00 | >>Or am I missing something and being an utter twat? Mmmmm.... before doing as Robo suggests - enter Windows Explorer, find the directory with all your files in it and make a backup copy of the directory. THEN play with batch files. |
Heather P (163) | ||
| 99797 | 2002-11-20 09:21:00 | That should do it I think robo, just make sure you do a test first. | -=JM=- (16) | ||
| 99798 | 2002-11-20 09:55:00 | I would hope that mike would take backups first, he's an IT professional after all. robo. |
robo (205) | ||
| 99799 | 2002-11-20 10:02:00 | Of course we trust Mike. But there may well be some less talented person searching this forum with a similar problem at a future date. A reminder about backups could prevent future howls of pain, rage and frustration. | Heather P (163) | ||
| 1 2 | |||||