| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| How do I save a workbook as a new workbook by using macros? | Excel Discussion (Misc queries) | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![Ctech[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
