I am currently in the process of doing a Zip Addin that will work similar to WinZip but with the added benifit of being available within Excel, via a userform AND being able to paste or drag & drop the extracted list to an Excel sheet.
(see image below - please note it is along way from finished)
One of the items I had to resolve was getting the type of file that I was listed within the Addin, this was solved by the use of the Shell32 dll. ( see Addin column [Type] )
See the code below to get your files type
eg. "Microsoft Excel worksheet","Executable file" etc