Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

Question

Hi I am creating an application for Generate Excel With Multiple Sheet from DataSet. But I am getting an error after running the application Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)). If i run application through default web server then applications works fine but on localhost ie custom server this error occurs I am using IIS7 and .net 4.0 version please help with this Thanks Archana

Pankaj Pandey · Answer

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.

Pankaj Pandey · Answer

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.

Pankaj Pandey · Answer

kindly also put here steps that you are follow to share the excel folder. Code is correct and working on my pc from wwwroot.

Pankaj Pandey · Answer

kindly paste here code which you are used.

Pankaj Pandey · Answer

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

C Sharp develpoer · Answer

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

SaiKiran Mandhala · Answer

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 permissions Appr 3: give the read / write permission to the IIS user or group users 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.

waheed rous · Answer

check this post

Archana Patil · Answer

As per your suggestion i have shifted application folder to wwwroot but still its giving the same error.Also i checked the two links given by you i tried solutions given but same error :(

Pankaj Pandey · Answer

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

Pankaj Pandey · Answer

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.

Archana Patil · Answer

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

Archana Patil · Answer

Is there any authentication problem

Archana Patil · Answer

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

Archana Patil · Answer

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(); } }

Archana Patil · Answer

Sorry But you are talking about the folder where excel file is stored or where my project code is stored

Pankaj Pandey · Answer

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

Archana Patil · Answer

D drive

Pankaj Pandey · Answer

where did you put code folder?

Archana Patil · Answer

I did this but its not working