Trying to control Internet Explorer with VBA, can someone help?

[mrdavie007]

I'm trying to download a file from my bank to import my transactions to excel. I've managed to write enough to get logged in and that's about it. I can't seem to much of anything from there. Here's the web site and 'demo' login info.
https://www.bancfirstonline.com/onlineserv/HB/Signon.cgi
Username '999999999' pass '1234'

I'd like to click on the 'Export' link and then enter info to get my file but like I said, I'm stuck. I've spent about 15 to 20 hours pouring over everything I can find online but I can't find what to do once I've slected the frame that the button is in. I believe ist's name is "primary." Am I just missing it? If anyone has any clue what's going on, I'd be very appreciative.

 

[Trevor G]

The details you added won't allow access.

My suggestion is. In Excel Record a macro and then select to use the Data Tab and From Web go through the motions of going to the website enter your details then select the table area to download into Excel.

Then once you have the details in Excel stop recording and you can then explore the code.

 

[mrdavie007]

Trevor
Thanks for the tip, I'll try that. Not sure why you couldn't login to the demo. I tried it twice just a moment ago. First time failed, the second succeeded and I don't know what I did different.

 

[Trevor G]

Just tried again didn't let me in.

How many 9's are you entering?

 

[mrdavie007]

Yeah, I got it. There are nine nines but the trick is you have to click the 'demo' button first and allow the popup, then go back to the other window and then log in. How annoying is all of that?

 

[Trevor G]

Using the web element in Excel doesn't give you the option to Select the table area, I don't know if this is because of it being a demo area!

However I did notice there is an option at the bottom to download as CSV file.

Have you been successful with the Recording Macro idea?

 

[mrdavie007]

The webquery won't work I think because of the security level. It doesn't let me select much of anything from any of the pages that are past the login even if I use my credintials. What I am trying to do is download the csv file but the trouble I'm having is selecting the 'Export' button to go to that page.

 

[Trevor G]

I have tried this to see if it will download, perhaps there is a better method, but it got data into my workbook.

Sadly I am not an expert with the webquerying options.

Sub Login_WebQuery()
Dim MyPost As String
Const MyUrl As String = "http://www.business-spreadsheets.com/forum.asp?t=103" 'Change URL
Const PostUser As String = "login=User Name" 'Change user name here
Const PostPassword As String = "&pass=password" 'Change password here

MyPost = PostUser & PostPassword

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & MyUrl, Destination:=Cells(1, 1))
.PostText = MyPost
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With

End Sub