Reading a zip file

Hi everyone,

I need to populate some cells in Excel with the name of the files in a given
zip file, and I am totally, completely and utterly stumped!!!

Any ideas???

TIA,
big t

I don't know of any utility that will give you the names of the files in a
zip archive in a way you can get into Excel. You may need to read the file
in binary form and decode it. The specs for a zip file can be found at:
http://www.pkware.com/company/standards/appnote/
It will be a challenge to write a routine to decode the file header info,
but that is all I can think of doing. Good luck!

"big t" wrote:

> Hi everyone,
>
> I need to populate some cells in Excel with the name of the files in a given
> zip file, and I am totally, completely and utterly stumped!!!
>
> Any ideas???
>
> TIA,
> big t
>

thanks for the info K, i'll have a go at that when i'm feeling adventurous!!

big t

"K Dales" wrote:

> I don't know of any utility that will give you the names of the files in a
> zip archive in a way you can get into Excel. You may need to read the file
> in binary form and decode it. The specs for a zip file can be found at:
> http://www.pkware.com/company/standards/appnote/
> It will be a challenge to write a routine to decode the file header info,
> but that is all I can think of doing. Good luck!
>
> "big t" wrote:
>
> > Hi everyone,
> >
> > I need to populate some cells in Excel with the name of the files in a given
> > zip file, and I am totally, completely and utterly stumped!!!
> >
> > Any ideas???
> >
> > TIA,
> > big t
> >