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.