[JansaNova]

I was wondering if any of you Excel gurus out there know how to
reference cells from Excel documents on the Internet.

I understand that...

If I'm referencing a cell from the same page (let's use F11 as the
referenced cell), it will look like the following:
=F11

If I'm referencing a cell from the same document (workbook), but not
the same page (let's use F11 as the referenced cell, and Page1 as the
referenced page), it will look like the following:
=Page1!F11

If I'm referencing a cell from a different document (workbook) (let's
use F11 as the referenced cell, Page1 as the referenced page, and
Document1 as the referenced Document), it will look like the
following:
='[Document1.xls]Page1'!F11

Now, what I'm basically asking, is how would I reference a different
Excel document that's on the Internet. Where would I include the web
address? Can this be done? I'm doing this for a friend at work - I'm
in Russia, so I'm just translating his question into English. Thank
you.

[Shades of Gray]

I believe that it might have to be done using VBA code, not directly. Is it possible to download the data?

Perhaps do a search on these superb Excel sites. I can guarantee that if it can be done, someone on these boards will know how to do it. The last one, also has a section for Mac specific issues related to Excel.

Ozgrid

Mr Excel

VBAX = VBA Express