Prompt for network password when export to excel

<i><b>Originally posted by : Janice (nglishan@hotmail.com)</b></i><br />I use this line of code to export my data to spreadsheet<br /> Response.ContentType = "application/vnd.ms-excel"<br /><br />But before I'm able to do so, my IIS system prompts me to enter network password and username.<br />What should I do or change to remove this prompt..?<br /><br />Anyone knows..?

<i><b>Originally posted by : steve</b></i><br />i presume the excel doc is on the web server and asking for a password. make sure the allow anonymous is check in the server properties and/or the anonyomous IIS login has read access to the dir that is resides in.<br /><br /><br />------------<br />Janice at 3/17/2000 2:59:38 AM<br /><br />I use this line of code to export my data to spreadsheet<br /> Response.ContentType = "application/vnd.ms-excel"<br /><br />But before I'm able to do so, my IIS system prompts me to enter network password and username.<br />What should I do or change to remove this prompt..?<br /><br />Anyone knows..?

<i><b>Originally posted by : Janice (nglishan@hotmail.com)</b></i><br />Is there any other way of doing?<br /><br />I cannot set anonymous login, because I need to do some authentication.<br /><br /><br />------------<br />steve at 3/20/2000 10:14:31 AM<br /><br />i presume the excel doc is on the web server and asking for a password. make sure the allow anonymous is check in the server properties and/or the anonyomous IIS login has read access to the dir that is resides in.<br /><br /><br />------------<br />Janice at 3/17/2000 2:59:38 AM<br /><br />I use this line of code to export my data to spreadsheet<br /> Response.ContentType = "application/vnd.ms-excel"<br /><br />But before I'm able to do so, my IIS system prompts me to enter network password and username.<br />What should I do or change to remove this prompt..?<br /><br />Anyone knows..?