Quote:
Originally Posted by photon
Ah ok yeah then I wouldn't worry too much about licensing or anything like that.
A VBA script in Excel would seem like the easiest, unfortunately I've never done it so can't help with that, but searching vba screen scrape excel looks like it comes up with some useful stuff.
http://stackoverflow.com/questions/2...site-using-vba |
A VBA script to pull the data from the website in Excel would probably do the job but it might be a pain to remember to run the script manually or remember to have your computer online when it is set to run.
It probably is easier to generate a file with a webservice hosted in the cloud set to run at a specific time and email it. Then you could have a VBA script in Excel parse out the files after you download them all. The one catch that both methods have is if they update the format of their website it might break the code that generates (parses out the HTML of the Website) the file.