Read filenames that are in a ZIP file

Hi,

I hope someone can help. I am writing something in Excel that will scan through all subfolders from where the spreadsheet resides and add all filenames it encounters into a spreadsheet.

The problem I have is some files may well be zipped and I would like to read the zip file to extract those filenames too.

So my question is, does anyone know how I can read the contents of a zip file into Excel?

Thanks for any suggestions.

Thanks for that. I did come across that while googling - I'm not sure why I didn't think to pick out the part I needed.