Linking to excel file on web?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nelson - 25 Jan 2008 08:24 GMT

Hi, I'm having trouble linking to an external .csv file located on a
website. Essentially I'd like to link to the 1st 3 columns of the
following.

http://www.asx.com.au/asx/downloadCsv/ASXListedCompanies.csv

Should I use the hyperlink function to achieve this?

thanks

Nelson

Reply to this Message

Matt Richardson - 25 Jan 2008 15:52 GMT

Hi,

All the HYPERLINK function will do is allow you to create a link to
the sheet in your cell in the same way you'd get a weblink in a
browser. Im not sure about how you could pull information directly
from a file sitting on another server in that way, but I'll be
interested to find out if it's possible.

Mat Richardson

> Hi, I'm having trouble linking to an external .csv file located on a
> website. Essentially I'd like to link to the 1st 3 columns of the
[quoted text clipped - 7 lines]
>
> Nelson

Reply to this Message