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

You will need to extract the excel file from the zip first before accessing it
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"


"The Moose" wrote:

> 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
>
>