How to move zip folder from one location to another location.

[Ratan Bhushan]

Hi Team

I would like to know whether there is anyway to move or copy zip folder from one location to another location by vba in excel.

Thanks
RatanB

 

[Chihiro]

You mean zip files? Or folder containing zip files?
Either case, you can adopt one of Ron's code for your need. Just look for ".zip" instead of ".xls" in his example.
http://www.rondebruin.nl/win/s3/win026.htm