Is this possible with excel vba? Auto download bank statements?

[shyy]

Hey guys,

I was wondering if this was possible to create a script where it can autodownload from bank websites to download monthly bank statements.
I have done macro for currency exchange rates, but not when it comes to actually downloading a pdf. Is this possible?

If not, is this even possible with regular VBA? What would I need to learn and know in order to get this done. I am guessing Microsoft SQL??

Thanks

 

[alansidman]

Have you looked at doing a web query? This link should help

http://www.vertex42.com/News/excel-web-query.html

Alan

 

[shyy]

Thanks, I actually used web query before to get exchange rates, don't this will do it though. After looking at a Microsoft link found

"NO DATA IS RETURNED FROM A SECURITY-ENHANCED SITE (SITES WHERE LOGIN IS REQUIRED)
Excel will not support getting data from security-enhanced Web sites that do not use Microsoft Windows NT® security. A common example of this would be a bank’s Web site that allows you to view your personal account information."

Hope there is a way around this. Would regular VBA do the trick?

 

[Minkowski]

i don't know if there is a way around with VBA
but i know it can be done with
a script

@echo off > tempscript.ftp & SetLocal EnableDelayedExpansion

>> tempscript.ftp echo open ftp.bank.net
>> tempscript.ftp echo Username
>> tempscript.ftp echo Password
>> tempscript.ftp echo bin
>> tempscript.ftp echo mget myfile.zip
>> tempscript.ftp echo quit

ftp -v -i -s:tempscript.ftp

del tempscript.ftp

exit

this is for an ftp server
but you can do it for website as well
pls don't ask me how

i saved this as a bat file
hope it helps a bit
regards.

 

[shyy]

Thanks I found a program that does work but for $695!

 

[PWil84]

Thanks I found a program that does work but for $695!

Were you ever able to download those bank statements to excel using VBA?