VBA - Send to Compressed Zip Folder

[LEVICC01]

Hi,

I have 3 files in a folder, that i have to send off every week. Each need to be zipped. Currently i have to manually navigate to the folder, right click, send to, compressed zip folder. Is there any way of using VBA to do this? Without opening the workbook in question?

 

[Trevor G]

Look at this archived thread

http://www.mrexcel.com/archive/VBA/28776.html

 

[LEVICC01]

Hi,

Many thanks.
Any way roudn it though without using a Shell command?

 

[Trevor G]

I haven't tried zipping workbooks without using the Shell command structure. Look here.

http://www.rondebruin.nl/7zipwithexcel.htm