Save workbook, in .zip

  • Thread starter Thread starter Ctech
  • Start date Start date
C

Ctech

Hi

Can someone help me with making a macro that save the active workbook
10 times with the names Rachael, Tim, Sara etc... in a .zip file

Workbooks name, a name, todays date.

i.e. Monthly Invoice report - Rachael M - 10.10.05.zip


Thanks
 
Hi

You can use SaveCopyAs (see VBA help) to save the file with different names before you use the zip code from my site.
 
Back
Top