I just need to be able to scrape the very top row of the table into the first row of Sheet1 in excel using VBA.
With the help of experts exchange ( see Excel VBA Web Data Scraping from a Table ). I can get the table data into excel using Internet Explorer object or TableObject but its very slow. I need to run the query many time with the range of account number 1-15,000 which will take weeks with the current methods.
How do I get the top row of the table data on the web into Excel row 1 on Sheet1 using the MSXML2 object? I am hoping this will be faster,