VBA to Edit Query and Login

Hello all,

Thank you in advance for your help. I've been struggling with this one!

I have a series of querytables in Excel 2010. I used the 'Get Data from Web' functionality to link to a series of web pages which contain the data I need. Each day I boot up Excel and log in again. Once I've logged in, Excel remembers for the day (by refreshing the tables every 5 minutes). However, I need to log in to those web pages first. The login page does not 'remember' who I am, and I cannot find any part of Excel which will login for me. So, I type in a username, then password, then click okay. If this was in a web scraper I think I could do it, but it is in Excel's "Edit Query" web page, which I can't seem to access programmatically.

I have looked at the properties for querytables and can't find anything relevant :-(
I have looked at VBA - using the Send Keys method to simulate my login. When I select a querytable using vba, the 'Data' tab at the top of Excel is greyed out. The 'alt' combinations do not work.
I have tried using VBA to left click the button I want, but again this does not work for me.

I would welcome any suggestions you have on how to take this forward! Thank you again.

So I solved it.

It's amazing what a few hours sleep can do.

Okay, so this page told me everything I needed to know:

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

In a nutshell, I needed to create a connection file which would contain the parameters I would use to access the system.