reading excel file from zip

I am just wondering if there is a way to read data from an excel file that is zipped. I have zipped excel files from last few months and I want to read the data from these files what's the best way to do that using a vba macro? Any idea is appreciated.

Thanks

Hello walid66,

Zipping a file alters it using a compression algorithm. The file must first be decompressed before Excel would be able to read it. What did you have in mind for this macro?

Sincerely,
Leith Ross

Every month we zip our data and put it on a server so if I want to read files from April or May i have to unzip them and put them somewhere and run a macro to read the data. I am wondering if there is a macro to unzip the file and put them in a temp directory and I can run my macro to read these files. After they are read they can be deleted from the temp directory.

I have found this site helpful in the past when working with zip files:

Unzipping
-----
http://www.rondebruin.nl/unzip.htm
http://www.rondebruin.nl/files/windowsxpunzip.txt

Zipping
-----
http://www.rondebruin.nl/windowsxpzip.htm

Thanks for your help. I will give it a try.

thanks it worked.