Excel object in ASP

[KLomax]

I am trying to use an excel spreedsheet on an asp.net page.
The follow code works (with output mod.) in a .net console
application. When I try to run this code in asp.net,
the "dim new excel app" statement fails
with "System.UnauthorizedAccessException: Access is
denied."
Are there some security settings I need to tweek to
instantiate an Excel object in VB.NET ?
Any ideas would be appreciated.
Regards,
KLomax

Try
Dim objExcel As New Excel.Application()
objExcel.Workbooks.Open("C:\TEMP\TestExcel.xls")
Label1.Text = _
objExcel.ActiveSheet.Cells(1,1).Value.ToString
objExcel.Workbooks.Close()
Catch exp As Exception
Label1.Text = exp.ToString
End Try

 

[MSFT]

By Default, an ASP.NET application will use the account "aspnet". This
account on your computer may not have enough permission to create the Excel
object. You can try to add this account to local administrators group, or
you can open up macine.config and look at the processModel' username
attribute, you will find which NT account your ASP.NET worker process is
running. Usually it's MACHINE or SYSTEM (where the latter one has more
rights to certain COM objects). See if you can play it with SYSTEM account.

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[KLomax]

Changing the processModel.username to "SYSTEM" did the
trick.

Thanks Luke