Originally Posted by
pradeepjassal
Hi
I need help to make a macro using Excel 2010 to rename All files (30) in a folder which is updated daily with files having current Date and Time its name, I have to rename these files to the required format as shown below:
Current File Name ...... Required File Name
ABC(09112012 0719).xls ...... ABC.xls
EFG(09112012 0720).xls ...... EFG.xls
HIJ(09112012 0720).xls ...... HIJ.xls
Each file name can be delimited using "(" , which may help making macro.
Thanks
Try this
It only rename the file that has
(8 digits number space 4 digits number)
just in front of extension.
So such like "ABC(09112012 0719)D.xls" will not be renamed.
Bookmarks