View Single Post
 
Old 03-02-2016, 04:37 AM
AndyDDUK AndyDDUK is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2012
Posts: 32
AndyDDUK is on a distinguished road
Default Save and rename attachments from ZIP FILE

Office 2013

Hi

I've seen several bits of code for saving and renaming attachments in Outlook but I can't get them to work for me

Reason is that I need VBA code to extract and rename files sent as a zip file attachment

For example, if I have a file called "FromCompanyA.zip" which contains a xls file called 01222.xls, I need this xls file renamed as yyyy-mm-dd_CompanyA.xls format

(yyyy-mm-dd is the creation date of the file name)


Zip files saved to eg C:\ZipFilesreceived
Renamed extracted files saved to C:\RenamedExtracts

Can you help me by supplying code?

Many thanks

Andy
Reply With Quote