Import Data To Excel 2003 with a login page
===

I am building a project and I understand that Excel 2003 supports the import of data from external webpages via "Data -> Import External Data -> New Web Query". 

This can be done via the few steps listed here: http://www.internet4classrooms.com/excel_import.htm

However, the site I am importing data from is an internal website (intranet) and it requires a login everytime I access it. The website does not remember the password and everytime I hit the "import" button, it doesnt do anything due to the login. How do I prompt for a username + password and login to the website while importing the data from an external website in Excel 2003? 

thank you in advance!