LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Replace first 8 letters of filename with Macro

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
replace letters for numbers Maria Teresa Excel Discussion (Misc queries) 5 June 4th 09 03:26 PM
Replace the column letters with my own heading Catter77 Charts and Charting in Excel 3 July 1st 08 02:40 AM
Formula to replace invalid filename characters tschultz Excel Worksheet Functions 2 January 27th 06 07:07 PM
Set Location and Filename to replace GetOpenFilename David Excel Programming 3 June 1st 05 02:29 PM
Looking for an easy way to replace letters with acutes Speak-ezy Excel Worksheet Functions 4 January 26th 05 05:04 PM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"