Zip a file from code

[brian b]

I have several xls files that I export from Access (2000). Can anyone
provide me the code (or a web site) that I can use to zip these files into
one file to be emailed?

 

[Lance]

Use the shell command and winzip command line calls ( link provided ).

http://www.memecode.com/docs/winzip.html

 

[Jonathan]

This web site was shared with me on this NG. I found the code works very
well. Go to:
http://home.modemss.brisnet.org.au/~mlevoi/ and click on the DOS and VB
Utilities link

Jonathan

 

[Bobby]

I'm using codes from this site:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
It's very useful.....thanks to Mr. Kallal