I have a lot of files automatically emailed to me daily which I need
for my reports. Although I've built Macros that open these and do the
updating automatically, I find that I am spending a considerable amount
of time unzipping files after downloading and putting them in the right
folders (I get a LOT of files).

My question: is there a way to circumvent this by having Excel access
zipfiles directly without having to manually unzip? Note that the files
after unzipping are in CSV format. I appreciate your help!