We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now


Website information gathering

mcrossland asked
Medium Priority
Last Modified: 2012-05-05
I have an associate that made a request the other day.

The company has numerous bank accounts some within one web login and others with other banks.

Her is what the request was.
They would like some type of automation that would log into the bank website, select the first account, find the current balance, and write it to a spreadsheet.  Then move on to the next account for that bank and do the same..  and so on.
Then access other online bank accounts and do the same.  
After the fact, I would like the spreadsheet emailed to certain recepients.  This is currently a manual daily proces but they would like it automated.

Watch Question

Top Expert 2006

I would not recommened that, especially the web logons. Any hacker good use that info.
I use online banking, and it obviously users a secure site. my userid is stored in cookies, all I ever do is enter my password credentials.

However if you do want it, you could try installing macro software. See what that does. Not sure how well it could work on secure servers.
Examples are listed here http://www.windowsdevcenter.com/pub/a/windows/2005/04/12/automate_xp.html
Dushan De SilvaTechnology Architect

If you are using AS400 , best is DB2 with PHP. (Use DB2 ODBC Connector).

BR Dushan
Top Expert 2006

Mike, the example I gave requires no coding, just settting up
if you want to develop it, what language do you want to use? because on Windows, there is WinInet, which can be used to access ftp and http sites. I just checked for https and apparently it does that also, though I have never tried it with that (I have done FTP though). http://support.microsoft.com/default.aspx?scid=kb;en-us;168151


other links regarding wininet


thank you very much.  My initial thought was a PC macro that would record every move and keystroke since I have to navagate and then get data into a spreadsheet, then email it daily.
there are a VERY large number of bank accounts that need to be reviewed daily and I am just trying save the treasurer some time in her busy day.


strange.  I noticed that Automate is on the top of the list.  This product is currently being used by one of our vendors to grab info from an AIX server and then either fax or email to recipients.  That would be great if we could use a software that we already own.  I know it does half the functions I'm looking for but not too sure about how it would navagate several bank websites and pull the daily balance.  Have you had experience with that product?
A must-have utility that automates time-consuming and repetitive computer tasks with customized hot keys, toolbars and much more. With QuicKeys the ability to customize and control your computer is virtually endless. Available now for Mac OS X, Windows, and Mac Classic.

Or Windows Power Pro (free):

I haven't used Windows Power Pro, but QuicKeys is VERY easy to use and is only $80 per user.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Top Expert 2006

If u want macros then here is a cuirrent topic  http://www.experts-exchange.com/Applications/Q_21798846.html which may be of interest

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.