View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Replace first 8 letters of filename with Macro

try
fileeditreplace

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hi-

I have a bunch of files that all begin with a date - 20051231. After
the date is the rest of the filename and this part of the filename
varies. What I want to do is REPLACE the 20051231 portion of every
file in a specific folder with FINAL 2005. To be more specific....I
have over 1,000 files that each start with the date and then go on with
a different name for each file. Example:

20051231_FileA
20051231_FileB
20051231_FileC

I would like to keep the "FileA" portion of every file....but replace
the 20051231 with FINAL 2005. Any ideas?

Any help is greatly appreciated!!

TIA,
Chris