Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Yahoo stock onfo
Message
 
À
30/06/1999 14:30:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00235812
Message ID:
00236144
Vues:
19
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform