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!

If you use Winzip see
http://www.rondebruin.nl/zip.htm
And
http://www.rondebruin.nl/unzip.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ups.com...
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!

Thanks Ron, this is helpful. Useful site too!