Forum Discussion
RBStewart
Mar 14, 2022Copper Contributor
Problem Creating a usable zip file using VBA. Does anyone have an alternative?
I am hitting a problem creating a usable zip file using VBA. I am using the following code block to create a zip file. I found it in virtually all internet posts that I came across and for that, I ...
GustavBrock
Mar 27, 2022MVP
I could replicate your issue, and modified my zip function to handle it:
The method used is simply to create the zip file in the temp folder and, when done, copy it to the removable drive.