Is there a way to go to a path on your network, like C:\TestIt\01 and zip up this folder using vba?
So then you would have a .zip folder in that same location.
Is there a way to go to a path on your network, like C:\TestIt\01 and zip up this folder using vba?
So then you would have a .zip folder in that same location.
You will either need to do something like mentioned here: https://accessexperts.com/blog/2012/...mmicrosoftvba/ or enlist a 3rd Party Software.
If you have the windows resource kit, you could execute shell statements. See http://serverfault.com/questions/390...e-command-line