Link to Web for Stock Quotes

[mcaoneill]

Good Morning,

I am trying to link a field in a form to the web to download current stock quotes once a day. I can input a hyperlink but I can't get it to return the actual price.

Any ideas?

Thank you
Maureen

 

[Robotron]

Maureen,

You would have to write code to get the html source for the webpage and then get the price from there. If you are attempting to do this, please post the code you have as it will be more helpful.

Phil Edwards

 

[PHV]

You may take a look at the DoCmd.TransferText method with TransferType:=acImportHTML or acLinkHTML.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244