IE or Excel?

[burger]

I need to retrieve data from this spreadsheet. I can do it by first saving the file and then using Excel functions. Is there any way possible to retrieve data from this spreadsheet without downloading it first?

http://www.mlindex.ml.com/GISPublic/bin/GI...dex%20Daily.csv

[PaulIA]

I need to retrieve data from this spreadsheet. I can do it by first saving the file and then using Excel functions. Is there any way possible to retrieve data from this spreadsheet without downloading it first?

I would think you would have to download the file first in order to extract data from it. The only other way I can think of would be to have some server side function that you could call that would extract the data for you.

[/dev/null]

I need to retrieve data from this spreadsheet. I can do it by first saving the file and then using Excel functions. Is there any way possible to retrieve data from this spreadsheet without downloading it first?

http://www.mlindex.ml.com/GISPublic/bin/GI...dex%20Daily.csv

well, can you extract a string from a local file WITHOUT looking into it??? If your answer is "no", why do you think that should be possible with a file on a web server?

Cheers

Kurt

Edited November 11, 2006 by /dev/null

[burger]

well, can you extract a string from a local file WITHOUT looking into it??? If your answer is "no", why do you think that should be possible with a file on a web server?

Cheers

Kurt

Because I have done so with html using IETableWritetoArray. That's why. The file is "open" but I still cannot retrieve data without downloading first. Apparently this is nessesary with CSV files. Edited November 11, 2006 by burger