Dear Ashish, Thanks alot for the help.
One thing more to add. Lets say Main Folder: Jan 2011>>> Sub Folder: 10 sub folder >>> 20 files each sub folder Can I rename all 200 files in one go. On Mar 7, 8:13 am, "OpenExcel.com" <ashishj...@openexcel.com> wrote: > *Replace* Characters in the Filenames of a > Directory<http://www.excelitems.com/2010/12/replace-characters-filenames-vba.html> > > Hi Ankit, > > This is such a simple problem and hence the solution, that I don't need to > provide long texts explaining that what it does. Simply, see the figure > below and you'll understand quite well that what would the macro below will > do or how you can enhance it your way. In a single line, I would still say > it REPLACES CHARACTERS/STRINGS in all filenames present in the provided > directory. Just a time saver and good to understand usage of DIR function. > > [image: Image:Replace Characters of Filenames ina directory] > > Click here to read full article and get a hint to solve your > problem.<http://www.excelitems.com/2010/12/replace-characters-filenames-vba.html> > > Tip: In the given macro, use > > lResult = Replace_Filename_Character("D:\FEB'11\", "FEB", "MAR") > > ------------------------------ > Excel VBA Interview > Questions<http://www.excelitems.com/2010/12/excel-vba-interview-questions.html> > Collection of Excel VBA > Macros<http://www.excelitems.com/2008/09/vba-macro-codes-examples-collection...> > > VLOOKUP<http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html> > > OFFSET<http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.h...> > ARRAY > formulas<http://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions...> > > > ------------------------------ > Excel 2003 Style Menu in Excel > 2007<http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-2007...> > Custom Number > Format<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-...> > > > SUMIFS<http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs...> > CONTACT a > TRAINER<http://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavst...> > <http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-2007...> > ------------------------------ > > Thanks & Regards > ------------------------------ > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified > Professional)http://www.excelitems.comhttp://www.openexcel.com > > Facebook <http://www.facebook.com/eXceLiTems> > Twitter<http://www.twitter.com/eXceLiTems> > LinkedIn <http://in.linkedin.com/in/ashishjain08> > LiveJournal<http://livejournal.excelitems.com/> > Digg <http://digg.com/excelitems> > Delicious<http://www.delicious.com/save?new=1&url=http%3A%2F%2Fwww.excelitems.c...> > Subscribe by > Email<http://feedburner.google.com/fb/a/mailverify?uri=excelitems> > ------------------------------ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
