98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Link to website
Link to website
Resolved · High Priority · Version 2010
Wed 19 Dec 2012, 14:39Delegate Richard said...
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
Wed 19 Dec 2012, 15:26Trainer Gary said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the default location for opening and saving spreadsheetsIf you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to. |
