View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ctech[_19_] Ctech[_19_] is offline
external usenet poster
 
Posts: 1
Default Save workbook, in .zip


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


--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=474716