.zip files

  • Thread starter Thread starter Ans
  • Start date Start date
A

Ans

Hi! Can anyone help me with this????
I'd like to open a .txt file placed in a .zip
archive, without unzip the archive, using VBA.
Is there a way doing that??????
 
As I read it, the OP wants to read a text file that's in an archive without
unzipping it from the archive first. Can't be done, AFAIK.
 
Ans said:
Hi! Can anyone help me with this????
I'd like to open a .txt file placed in a .zip
archive, without unzip the archive, using VBA.
Click to expand...

As others have stated no, you can't unzip using just VBA code. Unless
you want to write the VBA code yourself.

See Compression DLLs, OCXs, etc
http://www.granite.ab.ca/access/compression.htm for some options.

I use the open source free InfoZip dlls myself.

As Alex suggests I would unzip the txt file to the temp folder. See
the code at http://www.mvps.org/access/api/api0010.htm to determine
the temp folder name.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top