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