Winzipping A File in VBA Code

[GummowN]

I am full of tough challenges this week

I have already written code that checks the size of an export file, and if it is over a certain size runs winzip. But I am unsure on how to create a new winzip file, add in the export file and then close winzip (last one I know can be done with a sendkeys "%{f4}".

All help is welcome.

 

[cyoung]

Winzip has a command line interface that you can download. You can then use a simple shell statement to generate the zip file that you need.

Good luck!