This started off by helping myself to Dick’s code in ‘Removing Spaces from File Names’ (http://www.dailydoseofexcel.com/archives/2009/11/12/removing-spaces-from-file-names/) but quickly evolved to meet my own needs.
First, was the requirement to replace a certain text string by another. I added 3 parameters to the subroutine (Dirname, ReplaceWhat, and ReplaceBy). Also evident was that some files had [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/11/21/changing-names-of-some-files-in-a-directory/
Posted
Nov 21 2009, 11:21 PM
by
Daily Dose of Excel