I am looking for vba coding to add to attached Excel file with vba. I want to be able to click the "Get Date" button and take the symbols beginning in column A row 5 of the spreadsheet and go to web site to find associated dates. Then I want vba to retrieve the date and place it next to symbol in spreadsheet. I am attaching the Excel file for use to add the necessary code. I used IE8 and searched for the date, 23-NOV-10, and found it but do not know how to write the vba code to retrieve it. I want the vba code go down the column and retrieve the date for each symbol shown. The number of symbols in column "A" can be upwards or 300 plus.
Once in a while I get and error, but I think it is because I close the web site before the coding completes its iterations.
File is Excel 2007
Thanks in advance for your help!