Connecting to a SSL connection to DL transactions

[AUGuy]

First I'll preface this with I have no idea if this is even possible. I have a personal database that I use to categorize and calculate totals on my bank transactions. As it stands now, I login to the online banking, export a .CSV with the transactions, import it to the database, run the queries/vba to sort and categorize.

What I'd like to do is have some way to automate the download the transactions, perhaps with VBA.

I guess my question is, is this possible? If so, how do I go about setting it up?

Thanks in advance,

Guy

 

[janz]

Did you consider something like "http://www.autohotkey.com/" to create a macro to run the download.
You can then start the macro using VBA as soon as your program would open.
You could probably also make a macro to open your bank's website but that is all trial and error good luck.

 

[DJkarl]

I'm sure you can do this, there may be some third party software you can buy that would make it easier, but if you want to do it all natively you will need to reference the WinINet library and setup a secure connection and then write/post the raw html needed to interact with your bank's website. If you don't know what the you need to send you can get a program like Fiddler to capture the requests and responses so you know how to format your requests/responses.

Here is a link to the WinINet library on MSDN, sadly they only include C++ examples so it will take some conversion to get it to work in VBA.
http://msdn.microsoft.com/en-us/library/aa385483(v=vs.85).aspx

 

[AUGuy]

I'm sure you can do this, there may be some third party software you can buy that would make it easier, but if you want to do it all natively you will need to reference the WinINet library and setup a secure connection and then write/post the raw html needed to interact with your bank's website. If you don't know what the you need to send you can get a program like Fiddler to capture the requests and responses so you know how to format your requests/responses.

Here is a link to the WinINet library on MSDN, sadly they only include C++ examples so it will take some conversion to get it to work in VBA.
http://msdn.microsoft.com/en-us/library/aa385483(v=vs.85).aspx

Thanks, I kind of figured i'd need something to be able to see how they interact with each other. This will probably let me know at least part of the puzzle.