Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Excel Files
Hi All,
I have a group of about 20 Excel files in C:\Cars. All the files begin with 5 zeros. For example 00000_redcar.xls, 00000_bluecar.xls. I need a macro to replace the zeros in each file with another 5 digit number. For example 00000_redcar.xls would change to 12345_redcar.xls, 00000_bluecar.xls would change to 12345_bluecar.xls etc for all the files in the C:\Cars directory. Thanks so much for any help. Timwell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I rename files that are related. | Excel Discussion (Misc queries) | |||
Help to rename files | Excel Worksheet Functions | |||
Rename Files according to Excel | Excel Programming | |||
Rename Files | Excel Programming | |||
Need Macro to rename excel files | Excel Programming |