how to zip the output text file with password using 7-zip in ms access vba code?

[JohneX]

This Access(VBA) code works:

DoCmd.TransferText acExportFixed, "FILE Export Specification", "SOURCE_TABLE", "C:\test\output.txt", True

? Zip OUTPUT.txt file with password
? Delete Output.txt
? Retain Output.zip

 

[xenou]

Hi, quite a few hits on this when I google vba zip file.
Some links:
https://exceloffthegrid.com/vba-cod-to-zip-unzip/
http://excelexperts.com/Zip-Files-from-Excel
https://accessexperts.com/blog/2012/02/06/zipandunzipfrommicrosoftvba/
I can't speak to 7-zip though. I have only ever seen code for working with windows system zip utility.

 

[JohneX]

Hi, quite a few hits on this when I google vba zip file.
Some links:
https://exceloffthegrid.com/vba-cod-to-zip-unzip/
http://excelexperts.com/Zip-Files-from-Excel
https://accessexperts.com/blog/2012/02/06/zipandunzipfrommicrosoftvba/
I can't speak to 7-zip though. I have only ever seen code for working with windows system zip utility.

Thank you Sir!