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

T

The Moose

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
 
X

xlbo

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top