How do I refer to a table on the web? How to I refer to specific colums/row/cells in a web table?
Here's an example that may help you out. It goes to Yahoo's finance page (where I knew there would be a table) and finds the table with the mortgage rate. Then it finds the row for 15 year mortgages and writes the whole row to an Excel sheet. MSDN has help for these HTML objects here. Look for 'document', 'table', and 'td'.
Source: Daily Dose of Excel » Automation
No comments:
Post a Comment