I have a program that transfers about a dozen spreadsheets to a folder C:\MySpredsheets. I would like to use vba to zip up those spreadsheets into one zip folder. Then, for another program, I would like to use vba to unzip this zipped up folder to a pre-chosen (using the FileOpen API) folder.

Can you please help me?

Thanks,

Fiftyfour

See whether my article Working with Compressed (zipped) folders in MS Access helps.

Doug...that's exactly what I was looking for...thank you so much...