how to zip a file from VBA

  • Follow


Hi,

I would like to write a code that will zip a file. I would like to be able 
to specify the source file (e.g. Data.txt) and specify the name of the zip 
file (e.g. Data.zip). How can I do this?

I am using access 2007.

thanks! 


0
Reply Boon 2/11/2010 3:04:42 PM

http://www.databasejournal.com/features/msaccess/article.php/3835766/Working-with-Compressed-zipped-folders-in-MS-Access.htm

-- 
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Boon" <boonyawat.la-ongthong@cnh.com> wrote in message 
news:eXdcLuyqKHA.3536@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> I would like to write a code that will zip a file. I would like to be able 
> to specify the source file (e.g. Data.txt) and specify the name of the zip 
> file (e.g. Data.zip). How can I do this?
>
> I am using access 2007.
>
> thanks!
> 


2
Reply Douglas 2/11/2010 3:46:13 PM


1 Replies
1466 Views

(page loaded in 0.036 seconds)


Reply: