Opening an Excel file in the webserver

[karthik555]

Hello!

I am facing a problem in opening an XLS file available in the webserver.

Let us say I have File1.XLS in server SERV1 in the following Virtual Path.

http://SERV1/MyPath/File1.XLS.

I have the following piece of code in my ASP Page (Client side javascript)

	var Server_Address = window.location.href.split("/");
	var xl_url = "[URL unfurl="true"]http://"[/URL] + Server_Address[2] + "/MyPath/File1.xls";

	var oWB = oXL.Workbooks.Open(xl_url);

Now it opens "ENTER NETWORK PASSWORD DIALOG" with user name, password and domain.

Even if I click cancel, it opens the XLS file.

Same happens if I directly type in the path of the XLS in the IE address bar. But eventually the XLS file is opened in IE.

The files are in the drive of webserver which is NTFS partioned. But there is no specific security setting done to folder or files (just default. Everyone given all permission for all files in that folder). Also the webserver is IIS 5.0 running on Windows 2000 server.

In IIS for this virtual folder anonymous access is enabled with Integrated windows authentication.

Anything I am missing out in security setting.

Any response will be great help.

Thanks in advance.

Karthik

 

[Sheco]

So what exactly is the problem? You don't want the prompt to appear?

 

[karthik555]

Exactly. The user should be able to see the XLS file without having to type in the UID. In any case even if click cancel on that dialog it opens the file.

 

[Sheco]

Have you tried disabling anonymous access?