On the Developer Tab Insert a WebBrowser ActiveX control by clicking ... under the hammer and wrench.

Navigate the webbrowser to your login pageusing a macro.

Please Login or Register  to view this content.
After you have logged in you can now perform web queries in the authenticated system from this excel session.