Downloading a file from a url automatically.

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.cs...1c1ohgv&e=.csv

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

Any ideas would be greatly appreciated.

Philip

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

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).

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"

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: