Any way to use R1C1 notation to access an online spreadsheet that's
located inside a ZIP file??

I have to access two spreadsheets on the internet. For the first
spreadsheet, I can use R1C1 to pull the info into the format that I
want in my local spreadsheet.

The other spreadsheet (different company created the whole process) is
inside a ZIP file. Is there any way to use R1C1 to access data inside
a ZIP file. Or, do I need to download the ZIP first and then extract
the data??

Thanks.

Barb