Richard has attended:
Excel VBA Intro Intermediate course
Link to website
Hi all,
This is a general query as I can't hope to include all of the details.
We have lots of banks each with several currency accounts, and I would like to set up a spreadsheet which automatically logs in and downloads each table of transactions every day.
This is straightforward using a web query, but the login is the problem, along with changing the transaction date each day.
I have been searching around but would appreciate any pointers and links that might help me on my way. I am currently trying to combine a web query with vba using Send Keys, with limited success.
Thanks
Rich
RE: Link to website
Hi Rich
Thanks for getting in touch. Excel VBA is generally a poor language for this kind of activity; its connection strings for web queries are limited. ASP.NET would be a better language, or trying to find another way to pull down the transactions and grab them from another server via FTP.
Searching around this site found a reasonable workaround, but do dig through the comments as well as there are some interesting suggestions in there that might apply to your situation:
http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
I hope you find a solution.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
