export Query as excel in Zip File

[bhelmy]

hi
Need to Make buttom in form to export Query as excel but in a Zip or RAR file


thx

 

[Ranman256]

Export the data using :
docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, sQry, sFile, True, sTab

THEN zip it, using zip code here:
http://www.rondebruin.nl/win/s7/win001.htm
or
https://accessexperts.com/blog/2012/02/06/zipandunzipfrommicrosoftvba/

 

[arnelgp]

please take a look at this.

 

[Ranman256]

i cannot. yours is in a newer format than I can open.
i sent your solution previously.