Chase.com account activity via VBA

**losmi8** · 07-15-2010, 01:02 AM

Hi guys. Is there any way for me to import my Chase Bank's account activity via macro? I can do it manually by going through import data from web. But if I record a macro, it can't remember my login information and it won't work.

Is there any way to do this? Thank you!

**foxguy** · 07-15-2010, 09:39 AM

Hi losmi8;

I believe it can be done, but it takes someone better than me. I'm just bumping your message back to the top of the list, so I can watch it to see how it's done (hopefully).

**losmi8** · 07-17-2010, 04:24 PM

Thanks foxguy. Anyone out there know? I've looked all over and can't seem to find an answer. I'd like to get all of my bank accounts and credit card information populate in Excel. But starting off with Chase.com would be great as I have a few credit cards with them.

If anyone has any pointers, please share!

**Paul** · 07-17-2010, 05:50 PM

Hi Losmi,

Rather than re-invent the wheel, try Googling™ "vba fill in web form". In the first page alone there are several good examples of how to do this. You would just need to adjust any provided code to work on your site.

While you could code a macro to automatically send your username and password to the webpage, I would HIGHLY, HIGHLY.. HIGHLY recommend you don't do so. Excel is not a secure platform for sending private data and it would have zero encryption - that information would be stored as plain text within the vba module. Anyone who gained access to your Excel file could figure out your banking credentials.