I'm trying to open excel with asp .net using vb. I have the code right, but I'm getting this access denied error. I've tried to do what it says to fix it, but nothing works, I keep getting the same message. I've tried setting access rights to the "ASPNET" account to admin and I have changed the username/pass in the mashine.config file to "system/autogenerate" (this was suggested on microsoft's site).

Here's the message I get:
Server Error in '/WebApplication6' Application.
--------------------------------------------------------------------------------

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.

The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '{machinename}\ASPNET', which has limited privileges. Consider granting access rights to the resource to the ASP.NET process identity.

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 "{machinename}\ASPNET" user. Highlight the ASP.NET account, and check the Write box in the Allow column.

Source Error:


Line 31:
Line 32: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 33: Dim objExcelApp As New Excel.Application()
Line 34:
Line 35: objExcelApp.Charts.Add()


Source File: G:\WebServer\WebApplication6\WebForm1.aspx.vb Line: 33

Stack Trace:


[UnauthorizedAccessException: Access is denied.]
WebApplication6.WebForm1.Page_Load(Object sender, EventArgs e) in G:\WebServer\WebApplication6\WebForm1.aspx.vb:33
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0
Any ideas? I'm fairly desperate. If I get this to work, It will make my life incredibly easier.

Thanks,

Paul