*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.html> 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.html#more> ARRAY formulas<http://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html> ------------------------------ Excel 2003 Style Menu in Excel 2007<http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> Custom Number Format<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html> SUMIFS<http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html> CONTACT a TRAINER<http://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html> <http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> ------------------------------ Thanks & Regards ------------------------------ Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://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.com%2F&title=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloads&type=BOOKMARK&jump=http://www.delicious.com%2Fmountint&key=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-©user=mountint&via=mountint©tags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com> 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
