Opening Zipped files directly from Excel

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


<[email protected]> wrote in message news:[email protected]...
>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!