Hello all,
I found a brilliant code recently for saving attachments from multiple emails in 1 go, but I need to tweak it a little so it removes the date stamp from the file names and I am no sure how to do this.
Fo example, I have a few requests send over as "Requests_WH_18_12.xls" but I need them to be saved as "Requests_WH.xls"
(dropping the "_18_12")
anyone any thouhts?
Please Login or Register to view this content.
Are the files always .XLS files?
Are there always 6 characters you want stripped off the end of the filename?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
they are indeed always .XLS files JBeaucaire.
as to the file name, no unfortunately. (I thought it was....)
If iti s January first, the files are sent over to my team with "_1_1"), so 4 characters.
Then something like this to change the filename string right before you save it:
Please Login or Register to view this content.
hmmm.... the macro runs without errors, and states is saved 3 files (whch matches the email in question)
but.... when I move to the destination folder it remains empty. so looks like no files were actually saved.
what if I instead were to ask the tool to save the file with the RIGHT 15 characters (ans its current extension)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks