In an ASP page, my application must open an excel file with the
ExcelData.Worksheets.Open (FilePath) statement. It works with a dos path
(d:\temp\myfile.xls) but not with a UNC Path (\\ServerName\Temp\myfile.xls).

Can someone let me know how to solve this ?

My the way, I tried in VB Script, it worked.

Thank you

Regards

Patrick

What error do you get?  Permission denied?

From ASP all UNC file access looks to the OS like access to a remote machine
resource (even if it's a UNC for the server running the ASP).  An NT
challenge/response is required for access.  IIS can only respond if it has clear
text credentials, meaning you need to use Basic Authentication.

--
Michael Harris

| In an ASP page, my application must open an excel file with the
| ExcelData.Worksheets.Open (FilePath) statement. It works with a dos path
| (d:\temp\myfile.xls) but not with a UNC Path (\\ServerName\Temp\myfile.xls).
|
| Can someone let me know how to solve this ?
|
| My the way, I tried in VB Script, it worked.
|
| Thank you
|
| Regards
|
| Patrick
|
|