when performing a web query in Excel 2002 there is the option to login to the target site while building the web query. I need to perform the same task in Excel97 but there is no option for entering login name and password. Passing the username and password as part of the URL is not an option as the target server will not accept it.
Any help appreciated.