Retrieve Data from Web site
 

Hi all, i need to retrieve a certain figure from the following site
"http://www.lme.com/lead.asp"
I need to take the fValue for the "CASH BUYER" and insert it in a
Worksheet called "LEAD" in the workbook "TM-20 infosheet.xls" in column
"B" at the end of the data, with yesterday's date on the left in column
"A", however if it is a Monday then it must be Friday's date. If
possible i need to do this with the spreadsheet closed.

Any help and assistance with code would be appreciated.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***