#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to rename multiple Word file with same suffix | ozil61 | Word VBA | 2 | 05-06-2014 07:36 AM |
Have to rename file every time to save workbook | intelli | Excel | 3 | 03-27-2014 11:53 PM |
Rename Document & Save | d4okeefe | Word VBA | 4 | 05-23-2013 09:35 AM |
Rename File | cksm4 | Word VBA | 2 | 02-25-2011 09:29 AM |
code to save / rename / send attachments | unit213 | Outlook | 1 | 09-26-2007 08:15 PM |