Hello All,
i am using an excel sheet from the ASP.Net appliaction in my project.
But it is giving an error when i run it on the SERVER MACHINE.
the error is:

Access is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access is denied.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Source Error:
Line 939: Call GetExcel() Line 940: Line 941:
               Dim wrksheetPR As New Worksheet Line 942:
              Dim wrksheetRR As New Worksheet Line 943:

pls help.
its urgent.

thanks and regards,
muskaan.

I think no one is bothered to answer my questions........

anyways......thanx.......

regards,
muskaan.

Can anyone tell me How can I destroy excel sheet object without using API????

Thanks & Regards,
Muskaan.

Dim oXL As New Excel.Application
Dim oBooks As Excel.Workbooks = oXL.Workbooks
Dim oWB As Excel.Workbook = oBooks.Add
Dim oSheet As Excel.Worksheet = oXL.ActiveSheet

To destroy excel sheet object

NAR(oSheet)
oWB.Close(False)
NAR(oWB)
oBooks.Close()
NAR(oBooks)
oXL.Application.Quit()
NAR(oXL)
oXL = Nothing
GC.Collect()
GC.WaitForPendingFinalizers()



Public Sub NAR(ByVal o As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComO bject(o)
        Catch
        Finally
            o = Nothing
        End Try
    End Sub


Hope this will help you




Avanish Pandey
Set your heart upon your work, but never on its reward

Thanks Avinash......
will let u knw in case of further queries.........

regards,
muskaan.