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

Save workbook, in .zip
 

Hi

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ilyaskazi" wrote in message
...

For zipping, see this link whether it helps...

http://www.rondebruin.nl/windowsxpzip.htm


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