Hi all,

I am trying to retrieve data from the internet using the WebQuery function of Excel (Data->Import Data-> Web Query etc).
This all works fine, however I would like to retrieve data from an internet site at which i need to log in. Excel does not support this these steps.
My question: Is there a possibility to retrieve data using VBA and Query method at sites where I need to log-in, or another method? (I previously used Sendkeys method before using WebQuery, but due to the new Internet Explorer 7.0 keybinds do not work anymore).

Any help will be much appreciated...

Max