Save workbook, in .zip

[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

[ilyaskazi]

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

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

[Ron de Bruin]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>