I use a website to manage the cash balance in a network of ATMs.
The site displays a variety of information that I would like captured (data scraped) on a regular basis.
Use of Excel macros/VB or Imacros (preferred) to accomplish the following:
From a list of terminal #s (to be stored in an Excel sheet, web page/db or other method) and a specified date, pull the following information from [url removed, login to view]:
Current cash balance
Last transaction date & time
Total cash withdrawal for the specified date
and store that information in an Excel file and/or a web-based database.
When on Columbus data, the terminal # is selected from a drop down box and the date to be selected is entered in text box. The position of these items does not change.
I've attached a screen pic of the website to be scraped.