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
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
For zipping, see this link whether it helps...
http://www.rondebruin.nl/windowsxpzip.htm
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks