Thread
:
Replace first 8 letters of filename with Macro
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett