Excel and internet banking

[Sigma721]

Hi everyone

So first off, I understand this could be risky and I will protect the Excel sheet.

I have a system set up in Excel that requires me to download, copy and paste multiple bank accounts every day. Is it possible to set up the Excel to download these automatically everyday? I thought that Web Query would be the way to go, but this has issues with logging in.

Any thoughts?

 

[HavocXphere]

no - internet banking is specifically designed to make it difficult to pull data from it automatically

 

[howardb]

Can't you setup internet banking to generate daily CSV/Excel bank statements then save them in a set location on your PC; then link the individual fields/range to your master Excel sheet - most fields would be static on the bank's statement so you can reference the cells?
As long as it's setup correctly, each time you dump a new statement in the set location, your Excel sheet would read the fields/ranges you specified, pulling them in automatically...