Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

If the account which is running EXCEL is administrator then this will work:

For 64-bit (x64), create this folder: C:\Windows\SysWOW64\config\systemprofile\Desktop

For 32-bit (x86), create this folder: C:\Windows\System32\config\systemprofile\Desktop

Otherwise To resolve this issue follow these steps:

 

1.       Login to your Server as a administrator

2.       Go to "Start" -> "Run" and enter "MMC comexp.msc /32"

3.       Go to the properties of Microsoft Excel Application, under Identity, change it to The Interactive User from The Launching User (which is set by default).

4.       Go to the properties of Microsoft Office Excel 2007 Workbook, under Identity, change it to The Interactive User from The Launching User (which is set by default).

5.       Go to Security tab for Microsoft Excel Application and select Customize for

" Launch and Activation Permissions" and add ACCOUNT (under which EXCEL is running) to it and give it "Local launch" and "Local Activation" permission

6.       Go to Security tab for Microsoft Office Excel 2007 Workbook and select Customize for

" Access Permissions " and add ACCOUNT (under which EXCEL is running)  to it and give it "Local Access" permission

Hello,

You can solve this Access Denied in different ways.

Appr 1: You can set the user identity at Application Pool Level or impersonate the user in web.config.

     impersonate="true"     userName="User Name"     password="Password" />  

This should work. Make sure that the user has the access to the Folder.

If that doesn't work try this,

Appr 2: 

• Go to Control Panel - > Administrator -> Component Services -> DCOM Config
• Open Microsoft Word 97 - 2003 Properties
• General -> Authentication Level : None
• Security -> Customize all 3 permissions to allow everyone
• Identity -> This User -> Use ExcelUser /password
• Launch the Excel App to make sure everything is fine

3.Change the security settings of Microsoft Excel Application in DCOM Config.

Controlpanel --> Administrative tools-->Component Services -->computers --> myComputer -->DCOM Config --> Microsoft Excel Application.

Right click to get properties dialog. Go to Security tab and customize permissionsAppr 3:

1. give the read / write permission to the IIS user or group users

2. Start -> run -> inetmgr

   enable the ASP.NET authentication for your default website

3. For 64-bit (x64), create this folder: C:\Windows\SysWOW64\config\systemprofile\Desktop

For 32-bit (x86), create this folder: C:\Windows\System32\config\systemprofile\Desktop

The windows service, if running under the systemprofile, needs the Desktop folder. This folder was automatically created on XP and older Windows Server versions, but not for Vista and Windows 2008 Server.

Hope one of these steps should fix your issue. 

check this post

i amn sending some link that may heplfull for you


http://www.vbforums.com/showthread.php?657928-failed-due-to-the-following-error-80070005-Access-is-denied.


http://www.dotnetfunda.com/forums/thread5791-failed-due-to-the-following-error-80070005-access-is-denied.aspx

It will also work from wwwroot when you will use it online.


wwwroot is a folder where IIS user have fully right in default.

that's the reason i said to put ur application in root file.

I shifted the excel file folder to application folder but as you said to move aplication folder to wwwroot folder an share it .... i didn't get that why to do this i am going to use this code for online application....as you said it will work locally but what about online


Do I need to do any settings in IIS to fix this problem

I think here is authentication problem due to user that you are using.

But Not sure.

Try once that i suggested then lets see, what the problem shows.

I did same and it working properly, May be your system User not allowed to share this folder from IE.

Try one another way.

Put your excel folder in application folder and put your application folder in wwwroot also.

THer give all right and share your wwwroot folder .


also change path in your code.

then try it.

Right click folder > properties > Sharing > Share > user select (every one) > given all rights

also

properties > Sharing > Advance Sharing > share folder > user select (every one) > given all rights

kindly also put here steps that you are follow to share the excel folder.


Code is correct and working on my pc from wwwroot.

protected void btnGenExcel_Click(object sender, EventArgs e) { SqlConnection Conn = ApplicationInfo.GetConnection(); try { string FileName = "D:\\ExcelFolder\\Testing.xls"; DataSet ds = ResultExcelManager.Generate_ResultExcel(Conn); if(ds != null) { Application ExcelApp = new Application(); Workbook ExcelWorkBook = null; Worksheet ExcelWorkSheet = null; ExcelApp.Visible = true; ExcelWorkBook = ExcelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); List SheetNames = new List(); SheetNames.Add("Master"); SheetNames.Add("CheckBox"); SheetNames.Add("RadioButton"); SheetNames.Add("SingleTxtBox"); SheetNames.Add("MultiTextBox"); SheetNames.Add("TextArea"); SheetNames.Add("SingleRatingScale"); SheetNames.Add("MultiRatingScale"); for (int i = 1; i < ds.Tables.Count; i++) ExcelWorkBook.Worksheets.Add(); //Adding New sheet in Excel Workbook for (int i = 0; i < ds.Tables.Count; i++) { int r = 1; // Initialize Excel Row Start Position = 1 // ExcelWorkSheet = ExcelWorkBook.Worksheets[i + 1]; ExcelWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)ExcelWorkBook.Worksheets[i + 1]; //Writing Columns Name in Excel Sheet for (int col = 1; col < ds.Tables[i].Columns.Count; col++) ExcelWorkSheet.Cells[r, col] = ds.Tables[i].Columns[col - 1].ColumnName; r++; //Writing Rows into Excel Sheet for (int row = 0; row < ds.Tables[i].Rows.Count; row++) //r stands for ExcelRow and col for ExcelColumn { // Excel row and column start positions for writing Row=1 and Col=1 for (int col = 1; col < ds.Tables[i].Columns.Count; col++) ExcelWorkSheet.Cells[r, col] = ds.Tables[i].Rows[row][col - 1].ToString(); r++; } ExcelWorkSheet.Name = SheetNames[i];//Renaming the ExcelSheets } ExcelWorkBook.SaveAs(FileName); ExcelWorkBook.Close(); ExcelApp.Quit(); Marshal.ReleaseComObject(ExcelWorkSheet); Marshal.ReleaseComObject(ExcelWorkBook); Marshal.ReleaseComObject(ExcelApp); } } catch (Exception ex) { lblMessage.Text = ex.Message; } finally { Conn.Close(); Conn.Dispose(); } }

Try once after put in WWWROOt and then share it for everyone.

where did you put code folder?

hello,

Go to the folder From  where your Excel File is stored or read.

Go to property, sharing and share that folder for everyone.


This error will remove.


Thanks...

Mark as Answered if error removed