Dear all,
I have written some code that takes a selection of data and calculations from other files, and saves them as a new workbook in several places.
My problem is that one of the places where the work book is saved to is a restricted memory folder, and I need to be able to Zip the file when it saves.
Is there some code that will allow me to save a file as a .zip extension and will compress the file, or some code that will take the saved workbook and zip it?
Thanks