.zip files

[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??????

 

[bcap]

No.

 

[ceesdatabase]

Hello Ans,

I found this link
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1907653&SiteID=1

Have a look at Ron de Bruin's page on the subject.
http://www.rondebruin.nl/windowsxpzip.htm

grtz

 

[bcap]

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.

 

[Alex Dybenko]

Hi,
have a look here:
http://www.vbaccelerator.com/home/vb/code/Libraries/Compression/index.asp

you can unzip it to a temp folder and then open from there

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tony Toews [MVP]]

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.

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/