Hi All,
Need macro for renaming file as following:
Old Name = Campaign Agent Activity Report_20130320_074348
New Name = Campaign Agent Activity Report
Thanks in Advance
Hi All,
Need macro for renaming file as following:
Old Name = Campaign Agent Activity Report_20130320_074348
New Name = Campaign Agent Activity Report
Thanks in Advance
Isn't there an extension on that filename, too? You want to rename:
Campaign Agent Activity Report_20130320_074348.xls
to
Campaign Agent Activity Report.xls
?
So basically removing everything from the _ to before the .xls.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Yes this is what i m looking for
Do you need this done on every file in a specific folder, or only on a single file that you select each time the macro runs?
For following files only on path "C:\Users\wfm007\Downloads"
ACD Call Details Report II_20130321_064016.csv
ACD Call Interval Report III_20130321_071120.csv
Callback Request Report_20130321_071123.csv
Are you always looking for the 3 reports and stripping off the time stamp? So it's always just these 3 files in that folder with different time stamps?
Is that was is going on?
Yes to these files only not more then 3
try this then:
Please Login or Register to view this content.
Thanx a ton dear, it works
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks