Exception from HRESULT 0x800AC472. User tries to open a data entry form. System.Runtime.InteropServices.COMException with HRESULT: 0x800AC472, This interrupts the data from being written to the spreadsheet. Am Exporting Data in to Excel File,meanwhile if i open any other Excel file than the excel File on which am exporting data gets opened up Automatically having name Book1.How should i stop these excel file not to get open.In the Error log i get an error message showing " Exception from HRESULT: 0x800AC472". 24-Jun-10 20:02. I'm new to using the Studiox application and running into a runtime error with the 'Delete Row' command. Most people find this step solves their problem. Excel: Exception from HRESULT: 0x800AC472 Help Hi Welcome back to uipath community Kindly try with WORKBOOK ACTIVITIES with READ RANGE ACTIVITY instead of EXCEL APPLICATION SCOPE and try once That would work for sure Cheers @dgreen We're real tech professionals who love to solve problems together. Exception Details: System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800AC472 Source Error: An unhandled exception was generated during the execution of the current web request. Welcome to our community! After some poking around, it sounded like an issue of excel trying to access a workbook before it was ready. This exception generally comes if there are any licensing issues with Excel. "System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472". So when you are trying to insert a date value which is less than 1900, it will throw an exception. I have created a simple application to show the problem: Expand Copy Code. a) Click on File menu, click Options, Add-ins, Go button besides Manage: Com-in Add. We have tried following solution to resolve the issue: You can validate the date value as below. I have a production process that was running fine all of last week. The exception: System.Runtime.InteropServices.COMException was unhandled HResult=-2146777998 Message=Exception from HRESULT: 0x800AC472 Source=ExcelXlsx2Csv ErrorCode=-2146777998 StackTrace: at Microsoft.Office.Interop.Excel._Worksheet.Select (Object Replace) at ExcelXlsx2Csv.Program.Main (String [] args) in c:\Users\Edward\Documents\Visual . 21-Jun-10 20:45. retry = False Catch ex As Exception 'Need to try again, 'If this isn't the 0x800ac472 exception it should be re-thrown, 'Use Sleep (50) to reduce the number of retries, 'Use Exit Do or re-throw the exception to give up. The fix in this case was to close the child excel after performing any operations and then open up the master excel. Come for the solution, stay for everything else. Solution 2. Suddenly this morning I get the title message. 5 Comments 1 . Create the mysterious directory. In my case, there is a master excel which has an external connection through Pivot data source to another child excel. The operation "range.value2 = data" gets executed without any issues when the system is not locked. Regards, Srini Like (0) Posted: 1 year ago RajivB503 replied to raos @raos Actually this issue was coming at customer end. Create a directory "Desktop" if it does not already exist under. Exception from HRESULT: 0x800AC472. "C:\windows\system32\config\systemprofile\Desktop". You are getting the error because 4th Column in the Excel is a Date type Column. Leave a comment. After completion of generating excel report, still the excel.exe process running in the task manager. On editing the report we are getting the following COM exception. KaurGurpreet. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. However, when I lock the system and this operation is attempted, I get an exception message "Exception from HRESULT: 0x800AC472" when executing this operation. b) Check if there are add-ins listed, clear the checkbox. d) Now enable each add-in one at a time, restart the Excel, and repeat the above procedure. Excel Cells Mininum Date Value is 01/01/1900. The error is copied below and further details at the end. Due to what is thought to be a bug/oversight, a folder is required to exist by Excel when it is ran as a service. Solution: Activate Microsoft Office Excel inserting the Product Key then close and reopen it. About these exceptions, you could refer to the following link: Troubleshooting Exceptions: System.Runtime.InteropServices.COMException. Message: Exception from HRESULT: 0x800AC472 The entire workflow has ran a few times prior to this, but has continuously returned an error ever since. Please check if you have any licencing issues at your end and also check if there are any errors logged under Windows Event Viewer. c) Close the Office program and restart it. Symptom Error #1 Standard Error Source: Microsoft.Office.Interop.Excel Description: Exception from HRESULT: 0x800AC472 at Microsoft.Office.Interop.Excel.WorkbookClass.set_Saved(Boolean RHS) at Cognos.Controller.Forms.Common.fFrmFrangoFunc.InitExcelLink . Ideally, the user should be allowed to do this without causing an exception. I tracked the process through the macro though, and the macro errors out after sending the last email, before closing out the workbook. Visual Basic.NET Microsoft Excel Microsoft Visual Studio Microsoft Office. Need help on these.Thanks in Advance. It might look something like this: retry = True Do Try 'Put your call here. I tried adding a various delay times . In addition, I found that when you click end button, you will get a 'ThreadAbortException' exception, the running thread can not be stopped immediately. Re: Excel Exception from HRESULT: 0x800AC472. Try Try Dim zero As Integer = 0 Dim ecks As Integer = 1 \ zero Catch ex As Exception Throw New SecondLevelException( _ "Forced a division by 0 and threw " & _ "a second exception.", ex ) End Try Catch ex As Exception Console.WriteLine( ex.ToString( ) ) End Try End Sub End Module ' HResultDemo End Namespace ' NDP_UE_VB ' This example of . If the user tries to open Excel, user receives error #2. Did my solution solve your problem? The reported issue may occurs in the following scenarios, 1. End Try While retry System.Runtime.InteropServices.COMException: 'Exception from HRESULT: 0x800AC472' RGuillermo asked on 6/12/2018. If the child excel is opened by one excel scope and then if we try to open and perform activities on the master excel (Even after few seconds delay), it throws this exception. Referenced assembly could not found in GAC or local directory.