Pulling a value on a known line in the HTML source into an Excel spreadsheet -

i have series of order numbers, , want add status excel spreadsheet, update status changes.

i have set spreadsheet, , have created formula adds hyperlinks orders on site in separate column, have correct url every instance. these hyperlinks lead overview page particular order, on page there order status. unfortunately status isn't separate html table, can't use web query tool. know status can found within source code, , location remains constant across orders. i'm looking way pull in data allow refresh hourly, , allow me repeat process several hundred orders.

can shed light?

try using selenium-vba vba implementation of selenium.

selenium allows perfom automated tests in various languages (mainly java) , has developing tool firefox.

there problems selenium-vba , firefox (just aviod spend time current issue) can run test/routines chrome.