Any way to use R1C1 notation to access an online spreadsheet in a ZIP file??
 

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

Any way to use R1C1 notation to access an online spreadsheet in a
 

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