Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Yahoo stock onfo
Message
 
To
30/06/1999 14:30:26
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00235812
Message ID:
00236144
Views:
18
>This would just complicate automating your process, it doesn't make it impossible. If you find that you have to navigate from the front pge to get results, you'll just have to first navigate to the page using:
>
>oIE.Navigate("http://finance.yahoo.com/?u")
>oIE.Document.Forms(0).s.Value = "Dell"
>oIE.Document.Forms(0).Submit
>
>Then you should be able to get the link to the Excel file by checking the href property of the appropriate "a" member of the document.
>
>I found the one you are looking for by looping through the Document's Links Collection like so:
>
>FOR i = 1 TO oIE.Document.Links.Length
>IF oIE.Document.Links(i).InnerText = "Download Spreadsheet Format"
>oIE.Document.Links(i).Click()
>ENDIF
>ENDFOR
>
>and that takes you to the file. IE doens't give a way to manage downloading of files, so you have to deal with the Save As Dialog on your own.

Download the sendkeys ocx from the files section and you can send the keystrokes to save the quotes to the appropriate window. You'll also need some wait statements or even better type checking for various objects in the oie object. Otherwise, your code will overrun the html.
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform