Downloading a file from a url automatically.

[firsthelp]

Hello,

Yahoo Finance has a 'download spreadsheet' you can click on and download and open into excel, but I would like to automate that using a script to obtain the file, then I can process it and use the data.

The link below will take you to Yahoo Finance with our stock simbol.

http://finance.yahoo.com/q?s=thff&d=v1

If you click on 'download spreadsheet' it will ask if you want to open, or save the attachment.

http://finance.yahoo.com/d/quotes.csv?s=thff&f=sl1d1t1c1ohgv&e=.csv

I would like to find a better way to get this data downloaded to use.

Any ideas would be greatly appreciated.

Philip

[Waldo2k2]

no client side scripting language offers power of this magnitude.
look into server side scripting languages, they can do it :)

good luck

by the way if you know C/C++ or Java and the like and WinSock you could do it with an actual app

[Venkatas]

If you have control over the calling asp page then change the "content type" to Excell in the HTML tags. This will show the data in Excell Sheet at the Client(browser).

[zanechen]

1.create the activex control
2.Please use the VB 6.0's ¡°Package & Deployment Wizard¡±,make the ocx file into a .cab and a .html file
3.moidefy the CODEBASE="-----your location"

[Thread1]

For me, I'll go for active EXE document in VB. There's a built in http downloader (asynchread!? or something like that). It looks like a form. You can take advantage of the VB programming for the data manipulations or whatsoever stuffs :cool: