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
|