Share via

zip file properties

Anonymous
2011-10-07T14:34:03+00:00

hello, I have a number of .txt files in a folder. Those files have been zipped and they are now type .zip...Can vba pull the file name and size? This would be similar to when you right click on a file and where you are able to view the size...

Now remember that I don't need to "packed" file size but the actual .txt file size...

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-10-07T15:16:51+00:00

I could be wrong, but to the best of my knowledge VB cannot peek inside of a .zip file.  Even with the .zip extension on it.  The file properties returned would be the .zip file size, not the individual file sizes within it.  This is the reason that so many compressed file tools like WinZip, 7Zip, WinRAR, etc exist (along with the now built in ability of Windows to deal with showing you the contents of them).

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest