Guys,

I am trying to open an excel template from an ASP page. I have identity impersonate set to true in web.config, the file I am trying to access is in the root folder of my website, and all users have access.

When I try to open this file I am being asked for a logon, I want to get rid of this so it is seamless to the user.

I was thinking, if there was a way of mapping a network drive on the server, with predefined account credentials, then I could access the file in code using "wkbk = xl.Workbooks.Open("z:\HPTResults.xlt")" rather then giving the full unc path ? Could that get round my login problem ?

Thanks
Bob