It's working... thanks alot ashish... you are rocking!!!! On Mar 11, 8:13 am, ashish koul <koul.ash...@gmail.com> wrote: > hi' > > see if it helps > > first click on get file names then type the new names manually in col d and > run the rename macro > > > > > > On Tue, Mar 8, 2011 at 10:39 PM, Ankit <ankit.ha...@gmail.com> wrote: > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > P Before printing, think about the environment. > > rename all file names.xls > 3583KViewDownload- Hide quoted text - > > - Show quoted text -
-- ---------------------------------------------------------------------------------- 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