ASP.NET Excel Automation, Access is denied error

[ajain1008]

I'm running the following code on asp.net form

Dim objExcel As Excel.Application
Dim objWrkBk As excel.Workbook
objExcel = New excel.Application
objWrkBk = objExcel.Workbooks.Open("C:\Inetpub\wwwroot\ret\re t.xls")
objWrkBk.Close(SaveChanges:=True)
objWrkBk = Nothing
objExcel.Quit()
objExcel = Nothing

this runs fine on win forms but "Access is denied" error comes on
asp.net.

Is this impersonation problem, how to overcome?
I need this on asp.net, i have read
http://support.microsoft.com/defaul...b;en-us;Q257757 but then also i
have no other option.

thanks,
Shattar

[Ken Tucker [MVP]]

Hi,

I would not use excel to create an xls in a web project. Try this
method instead.

http://support.microsoft.com/default...b;en-us;319180

Ken
----------------
<aj*******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I'm running the following code on asp.net form

Dim objExcel As Excel.Application
Dim objWrkBk As excel.Workbook
objExcel = New excel.Application
objWrkBk = objExcel.Workbooks.Open("C:\Inetpub\wwwroot\ret\re t.xls")
objWrkBk.Close(SaveChanges:=True)
objWrkBk = Nothing
objExcel.Quit()
objExcel = Nothing

this runs fine on win forms but "Access is denied" error comes on
asp.net.

Is this impersonation problem, how to overcome?
I need this on asp.net, i have read
http://support.microsoft.com/defaul...b;en-us;Q257757 but then also i
have no other option.

thanks,
Shattar

[ajain1008]

Thanks Ken,

i know it's not recommended. however consider this :

Client updates excel once a month which contain vba and formulaes.
Members inputs data which is exported into excel and then report is
generated from data imported from excel.

i can use odbc to input and extract data but unless i open excel and
save it, calculations do not take part, so this is the reason i have to
open save and close excel file.

if there is some other solution to fire calculations without using
automation pls. tell.

by-the-way i solved impersonation problem by registering aspnet user to
run excel application in dcom configuration.

regards,
Shattar