[AccessD] Automating file downloads from the Web

Stuart McLachlan stuart at lexacorp.com.pg
Wed May 25 16:38:17 CDT 2005


On 25 May 2005 at 15:50, Hale, Jim wrote:

> I have created an Access database that parses Bank of America credit card
> Merchant statements. I manually download individual merchant statements from
> B of A's web site and process them with Access. All this works wonderfully
> well. The problem is we have 158 stores (merchant statements) that have to
> be downloaded. Each download requires clicking through about 5 separate
> screens. It takes about 4 hours. B of A has made it abundantly clear they
> can not provide a disc with all the statements or any other means to
> download the statements in a group so I am left to my own devices. Is there
> any kind of script/key macro/magic I can write to at least semi automate the
> download process? Any help would be appreciated since I have some clerks
> ready to lynch me. TIA
> 

Take a look at AutoIt from www.autoitscript.com/autoit3/
It's a scripting language which is good at this sort of automation.

-- 
Stuart





More information about the AccessD mailing list