Error HRESULT: 0x800401A8 in RPA Starter Module Currency Converter bot exercise

Im getting this error when doing the Currency Converter exercise. With respect i am not a developer so I need the solution really stepped out simply for me to understand how to fix it.:Ive checked the excel files and they both contain simple inputs and no formulas.
Whilst i could move on through the course i would like to get this right before continuing.

20.4.1

Source: Excel For Each Row

Message: Exception from HRESULT: 0x800401A8

Exception Type: System.Runtime.InteropServices.COMException

RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800401A8
at Microsoft.Office.Interop.Excel._Worksheet.get_Name()
at UiPath.Excel.ExtendedWorkbookApplication.get_CurrentWorksheetName()
at UiPath.Excel.CurrentRowQuickHandle.IsCurrentRowVisible()
at UiPath.Excel.CurrentRowQuickHandle.System.Collections.IEnumerator.MoveNext()
at UiPath.Shared.Activities.Business.ForEachEnumeratorExtensions.Iterate[T](Variable1 enumeratorVariable, NativeActivityContext context, ActivityInstance completedInstance, Boolean exitLoop, Action1 doAction, Action1 completedAction, Action1 exitAction)
at UiPath.Excel.Activities.Business.ExcelForEachRow.InternalExecute(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.ActivityCompletionCallbackWrapper.Invoke(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.CompletionCallbackWrapper.CompletionWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Can you please post a picture of your flow?

hi @dilollo1

Please check this

Regards
Gulshiyaa

I too was doing the currency converter exercise (and not a developer), but the excel add-in was failing to show as successful in studioX. I see it in add-ins and trust center just fine, but when I tried working through the exercise without it showing a valid add-in implementation, and got to the step when writing a cell and “where to write”, I got the error: 20.4.1-beta.22 Exception from HRESULT: 0x800A01A8. Not sure where to go from here.

This is what I tried:
Removing the add-in
Checking trust center settings
restarting studioX
Restarting Excel/M365
Killing any tasks in Windows

none worked.

Here’s the log in case it can help here:
[6/4/2020 3:13:26 PM] ---------------start---------------
[6/4/2020 3:13:26 PM] Running script at 06/04/2020 15:13:26 on MACHINE
[6/4/2020 3:13:26 PM] Trying to install the UiPath ExcelAddIn
[6/4/2020 3:13:26 PM] Studio base path is C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022
[6/4/2020 3:13:26 PM] RepairOnly mode is False
[6/4/2020 3:13:26 PM] Found VSTO registry key HKLM:\SOFTWARE\Microsoft\VSTO Runtime Setup\v4
[6/4/2020 3:13:26 PM] VSTO runtime version is 10.0.60828
[6/4/2020 3:13:26 PM] Creating registry key HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn
[6/4/2020 3:13:26 PM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn FriendlyName
[6/4/2020 3:13:26 PM] System.Management.Automation.PSArgumentException: Property FriendlyName does not exist at path HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn.
[6/4/2020 3:13:26 PM] Add registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn FriendlyName with value UiPath.Integration.ExcelAddIn
[6/4/2020 3:13:26 PM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Description
[6/4/2020 3:13:26 PM] System.Management.Automation.PSArgumentException: Property Description does not exist at path HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn.
[6/4/2020 3:13:26 PM] Add registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Description with value UiPath.Integration.ExcelAddIn
[6/4/2020 3:13:26 PM] UiPath ExcelAddIn path is C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto
[6/4/2020 3:13:26 PM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Manifest
[6/4/2020 3:13:26 PM] System.Management.Automation.PSArgumentException: Property Manifest does not exist at path HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn.
[6/4/2020 3:13:26 PM] Add registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Manifest with value file:///C:\Users\UserX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto|vstolocal
[6/4/2020 3:13:26 PM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn LoadBehavior
[6/4/2020 3:13:26 PM] System.Management.Automation.PSArgumentException: Property LoadBehavior does not exist at path HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn.
[6/4/2020 3:13:26 PM] Add registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn LoadBehavior with value 3
[6/4/2020 3:13:26 PM] Adding the add-in to the VSTO security inclusion list
[6/4/2020 3:13:26 PM] Checking inclusion key @{PublicKey=[Blocked]AQAB; Url=file:///C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto; PSPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\c9217c8d-d5c7-4bcf-be88-ab17a47b1f43; PSParentPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion; PSChildName=c9217c8d-d5c7-4bcf-be88-ab17a47b1f43; PSProvider=Microsoft.PowerShell.Core\Registry}
[6/4/2020 3:13:26 PM] Checking inclusion url file:///C:\Users\userx\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto
[6/4/2020 3:13:26 PM] Removing existing inclusion entry for this url
[6/4/2020 3:13:26 PM] RSAKeyValue is [Blocked]AQAB
[6/4/2020 3:13:26 PM] Check registry value exists HKCU:\Software\Microsoft\VSTO\Security\Inclusion\ea86b7f7-4678-4f82-bd6e-d74cda904281 PublicKey
[6/4/2020 3:13:26 PM] System.Management.Automation.PSArgumentException: Property PublicKey does not exist at path HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\ea86b7f7-4678-4f82-bd6e-d74cda904281.
[6/4/2020 3:13:26 PM] Add registry value HKCU:\Software\Microsoft\VSTO\Security\Inclusion\ea86b7f7-4678-4f82-bd6e-d74cda904281 PublicKey with value [Blocked]AQAB
[6/4/2020 3:13:26 PM] Check registry value exists HKCU:\Software\Microsoft\VSTO\Security\Inclusion\ea86b7f7-4678-4f82-bd6e-d74cda904281 Url
[6/4/2020 3:13:26 PM] System.Management.Automation.PSArgumentException: Property Url does not exist at path HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\ea86b7f7-4678-4f82-bd6e-d74cda904281.
[6/4/2020 3:13:26 PM] Add registry value HKCU:\Software\Microsoft\VSTO\Security\Inclusion\ea86b7f7-4678-4f82-bd6e-d74cda904281 Url with value file:///C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto
[6/4/2020 3:13:26 PM] ImportSigningCertificate dllPath is C:\Users\userx\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.dll
[6/4/2020 3:13:26 PM] ImportSigningCertificate Importing SignerCertificate into the CurrentUser TrustedPublisher store
[6/4/2020 3:13:26 PM] ImportSigningCertificate - SignerCertificate imported successfully
[6/4/2020 3:13:28 PM] StartExcelAndCheckAddInConnection - COMAddIns.Count: 1
[6/4/2020 3:13:28 PM] StartExcelAndCheckAddInConnection - ComAddIn detected: ABBYY FineReader 11 MSExcel COM Add-In
[6/4/2020 3:13:28 PM] StartExcelAndCheckAddInConnection - UiPath ComAddIn not valid
[6/4/2020 3:13:28 PM] OfficeAddInSetup Error:
[6/4/2020 3:13:28 PM] Finished ExcelAddIn installation at 06/04/2020 15:13:28

Please go to navigate to this location %LocalAppData%\UiPath\Logs delete all files, then start studiox and try an indicate then please collect all the log files and attach them to this post.

Hello Mircea,
I did and got this portion of the log on that event:
Log portion start —>
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off

11:24:29.7870 => [ERROR] [UiPath.Studio.exe] [13] UiPath.Excel.ExcelException: Exception from HRESULT: 0x800A01A8 —> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A01A8
at Microsoft.Office.Interop.Excel._Workbook.get_FullName()
at UiPath.Excel.ExcelWrapperFactory.FindExistingWorkbook(Application excelApp
at UiPath.Excel.ExcelWrapperFactory.CreateDesignTimeExcelWrapper(WorkbookArguments workbookArguments
— End of inner exception stack trace —
at UiPath.Excel.ExcelWrapperFactory.CreateDesignTimeExcelWrapper(WorkbookArguments workbookArguments
at UiPath.Excel.ExcelWrapperFactory.<>c__DisplayClass2_0.b__0()
at UiPath.Excel.ExcelWrapperFactory.RunInCriticalSection(Func`1 func)
at UiPath.Excel.ExcelWrapperFactory.AutoCompleteAttachOrCreateNew(WorkbookArguments workbookArguments)
at UiPath.Excel.Activities.Design.Services.ExcelAutoCompleteService.OpenExpressionTool(Type autocompleteType
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.ExpressionTextBoxEnhancements.ExpressionPopupButton.AssistantMenuFactory.<>c__DisplayClass7_0.b__0()
Log portion end —>

(there were many more lines in the log file, which I am posting in entirety below):

<----- full log start
11:23:36.8233 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieving RegistrationState.
11:23:36.8726 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal
11:23:37.0411 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieved RegistrationState value ActiveLicense.
11:23:37.0411 => [WARN] [UiPath.Studio.exe] [1] Warn: Handling update online operation.
11:23:37.1182 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieving LicenseInfo.
11:23:37.1182 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal
11:23:37.1338 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieved LicenseInfo value RegistrationState: ActiveLicense
11:23:37.1338 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieving RegistrationState.
11:23:37.1338 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal
11:23:37.1475 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieved RegistrationState value ActiveLicense.
11:23:37.1475 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieving license content.
11:23:37.1475 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal
11:23:37.2359 => [WARN] [UiPath.Studio.exe] [1] Warn: Retrieved license content UiPath.Licensing.Library.Core.Models.LicensePayload.
11:23:40.4517 => [ERROR] [UiPath.Studio.exe] [1] System.ArgumentNullException: Value cannot be null.
Parameter name: key
at System.Collections.Generic.Dictionary2.FindEntry(TKey key) at UiPath.Studio.Shared.Services.ResourceIconsService.GetBrushFromKey(String key) 11:23:42.5513 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal 11:23:42.5562 => [WARN] [UiPath.Studio.exe] [1] Warn: Handling online update license request with current state :ActiveLicense 11:23:42.5562 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal 11:23:42.5562 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal 11:23:42.5718 => [WARN] [UiPath.Studio.exe] [1] Warn: Handling activate online operation to https://activate.uipath.com with license code 9319-8997-66-****-**** 11:23:46.2207 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal 11:23:46.2324 => [WARN] [UiPath.Studio.exe] [1] Warn: Current license folder path: C:\Users\userX\AppData\Roaming\UiPath\LicenseInternal 11:23:46.2988 => [WARN] [UiPath.Studio.exe] [1] Warn: Handled update online. 11:23:56.7422 => [WARN] [UiPath.Studio.Shared.Logging.OutputLogger] [16] NU3034: Package 'Extended.Wpf.Toolkit 2.8' from source 'https://gallery.uipath.com/api/v2': This package is signed but not by a trusted signer. 11:23:57.8721 => [ERROR] [UiPath.Studio.exe] [18] System.NullReferenceException: Object reference not set to an instance of an object. at UiPath.Studio.Orchestrator.Folders.Services.RefreshFoldersJobExecutor.ParseValueFieldInJson[T](String jsonData) at UiPath.Studio.Orchestrator.Folders.Services.RefreshFoldersJobExecutor.<GetResources>d__131.MoveNext()
11:24:05.8491 => [WARN] [UiPath.Studio.exe] [1] Feature LibraryServiceV1 is not supported
11:24:05.8501 => [WARN] [UiPath.Studio.exe] [1] Feature LibraryServiceV1 is not supported
11:24:05.8501 => [WARN] [UiPath.Studio.exe] [1] Feature LibraryServiceV1 is not supported
11:24:07.2124 => [ERROR] [UiPath.Studio.exe] [1] System.Xml.XmlException: ’’
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char data
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlReader.MoveToContent()
at System.Xml.Linq.XElement.Load(XmlReader reader
at System.Xml.Linq.XElement.Parse(String text
at UiPath.Activities.Api.Workflow.Wizards.WizardExtensions.TryGetDictionary(String dictionaryPath)
11:24:07.6977 => [ERROR] [UiPath.Studio.exe] [1] System.Xml.XmlException: ’’
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char data
at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlReader.MoveToContent()
at System.Xml.Linq.XElement.Load(XmlReader reader
at System.Xml.Linq.XElement.Parse(String text
at UiPath.Activities.Api.Workflow.Wizards.WizardExtensions.TryGetDictionary(String dictionaryPath)
11:24:10.7563 => [ERROR] [UiPath.Studio.exe] [25] $LoadAssembly: UiPath.UIAutomationNext
File name: 'Emgu.CV.World
at System.RuntimeTypeHandle.GetDeclaringType(RuntimeType type)
at System.RuntimeType.RuntimeTypeCache.GetEnclosingType()
at System.RuntimeType.get_DeclaringType()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#gFc(Type #4Ub)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.<>c.#yNk(Type #gi)
at System.Linq.Enumerable.WhereArrayIterator`1.MoveNext()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#XEc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#iFc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#30j(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.GetOrCreate(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#uBh(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(String fullName)
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.SyntaxService.LoadAssembly(LoadIntellisenseAssembliesContext context

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off

11:24:12.4262 => [ERROR] [UiPath.Studio.exe] [25] $LoadAssembly: UiPath.UIAutomationNext
File name: 'Emgu.CV.World
at System.RuntimeTypeHandle.GetDeclaringType(RuntimeType type)
at System.RuntimeType.RuntimeTypeCache.GetEnclosingType()
at System.RuntimeType.get_DeclaringType()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#gFc(Type #4Ub)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.<>c.#yNk(Type #gi)
at System.Linq.Enumerable.WhereArrayIterator`1.MoveNext()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#XEc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#iFc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#30j(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.GetOrCreate(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#uBh(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(String fullName)
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.SyntaxService.LoadAssembly(LoadIntellisenseAssembliesContext context

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off

11:24:12.5590 => [ERROR] [UiPath.Studio.exe] [25] $LoadAssembly: UiPath.UIAutomationNext
File name: 'Emgu.CV.World
at System.RuntimeTypeHandle.GetDeclaringType(RuntimeType type)
at System.RuntimeType.RuntimeTypeCache.GetEnclosingType()
at System.RuntimeType.get_DeclaringType()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#gFc(Type #4Ub)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.<>c.#yNk(Type #gi)
at System.Linq.Enumerable.WhereArrayIterator`1.MoveNext()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#XEc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#iFc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#30j(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.GetOrCreate(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#uBh(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(String fullName)
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.SyntaxService.LoadAssembly(LoadIntellisenseAssembliesContext context

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off

11:24:14.5830 => [ERROR] [UiPath.Studio.exe] [25] $LoadAssembly: Microsoft.Exchange.WebServices.Auth
File name: 'Microsoft.IdentityModel
at System.Signature.GetSignature(Void* pCorSig
at System.Reflection.RuntimePropertyInfo.get_Signature()
at System.Reflection.RuntimePropertyInfo.get_PropertyType()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#aFc(#Lrc #wAf
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#cFc(#hsc #4Ub
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#XEc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#iFc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#30j(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.GetOrCreate(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#uBh(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(String fullName)
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.SyntaxService.LoadAssembly(LoadIntellisenseAssembliesContext context

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off

11:24:16.3652 => [ERROR] [UiPath.Studio.exe] [25] $LoadAssembly: Microsoft.Exchange.WebServices.Auth
File name: 'Microsoft.IdentityModel
at System.Signature.GetSignature(Void* pCorSig
at System.Reflection.RuntimePropertyInfo.get_Signature()
at System.Reflection.RuntimePropertyInfo.get_PropertyType()
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#aFc(#Lrc #wAf
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#cFc(#hsc #4Ub
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#XEc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.BinaryAssemblyLoader.#iFc(Assembly #sxc)
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#30j(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.Create(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.FileBasedAssemblyRepository.GetOrCreate(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.#uBh(Assembly #sxc
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(Assembly assembly
at ActiproSoftware.Text.Languages.DotNet.Reflection.Implementation.AssemblyRepositoryBase.Load(String fullName)
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.SyntaxService.LoadAssembly(LoadIntellisenseAssembliesContext context

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off

11:24:29.7870 => [ERROR] [UiPath.Studio.exe] [13] UiPath.Excel.ExcelException: Exception from HRESULT: 0x800A01A8 —> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A01A8
at Microsoft.Office.Interop.Excel._Workbook.get_FullName()
at UiPath.Excel.ExcelWrapperFactory.FindExistingWorkbook(Application excelApp
at UiPath.Excel.ExcelWrapperFactory.CreateDesignTimeExcelWrapper(WorkbookArguments workbookArguments
— End of inner exception stack trace —
at UiPath.Excel.ExcelWrapperFactory.CreateDesignTimeExcelWrapper(WorkbookArguments workbookArguments
at UiPath.Excel.ExcelWrapperFactory.<>c__DisplayClass2_0.b__0()
at UiPath.Excel.ExcelWrapperFactory.RunInCriticalSection(Func`1 func)
at UiPath.Excel.ExcelWrapperFactory.AutoCompleteAttachOrCreateNew(WorkbookArguments workbookArguments)
at UiPath.Excel.Activities.Design.Services.ExcelAutoCompleteService.OpenExpressionTool(Type autocompleteType
at UiPath.Studio.Plugin.Workflow.ExpressionEditor.ExpressionTextBoxEnhancements.ExpressionPopupButton.AssistantMenuFactory.<>c__DisplayClass7_0.b__0()
full log end—>

This is the log when trying to reinstall the excel add-in:
[6/5/2020 11:40:45 AM] ---------------start---------------
[6/5/2020 11:40:45 AM] Running script at 06/05/2020 11:40:45 on MACHINE
[6/5/2020 11:40:45 AM] Trying to install the UiPath ExcelAddIn
[6/5/2020 11:40:45 AM] Studio base path is C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022
[6/5/2020 11:40:45 AM] RepairOnly mode is False
[6/5/2020 11:40:45 AM] Found VSTO registry key HKLM:\SOFTWARE\Microsoft\VSTO Runtime Setup\v4
[6/5/2020 11:40:45 AM] VSTO runtime version is 10.0.60828
[6/5/2020 11:40:45 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn FriendlyName
[6/5/2020 11:40:45 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn FriendlyName with value UiPath.Integration.ExcelAddIn
[6/5/2020 11:40:45 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Description
[6/5/2020 11:40:45 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Description with value UiPath.Integration.ExcelAddIn
[6/5/2020 11:40:45 AM] UiPath ExcelAddIn path is C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto
[6/5/2020 11:40:45 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Manifest
[6/5/2020 11:40:45 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn Manifest with value file:///C:\Users\rninja\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto|vstolocal
[6/5/2020 11:40:45 AM] Check registry value exists HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn LoadBehavior
[6/5/2020 11:40:45 AM] Update registry value HKCU:\Software\Microsoft\Office\Excel\AddIns\UiPath.Integration.ExcelAddIn LoadBehavior with value 3
[6/5/2020 11:40:45 AM] Adding the add-in to the VSTO security inclusion list
[6/5/2020 11:40:45 AM] Checking inclusion key @{PublicKey=[BLOCKED]AQAB; Url=file:///C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto; PSPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\f8ccf60d-34ee-4daa-842b-cb9d9a078c86; PSParentPath=Microsoft.PowerShell.Core\Registry::HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion; PSChildName=f8ccf60d-34ee-4daa-842b-cb9d9a078c86; PSProvider=Microsoft.PowerShell.Core\Registry}
[6/5/2020 11:40:45 AM] Checking inclusion url file:///C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto
[6/5/2020 11:40:45 AM] Removing existing inclusion entry for this url
[6/5/2020 11:40:45 AM] RSAKeyValue is [Blocked]AQAB
[6/5/2020 11:40:45 AM] Check registry value exists HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5284e747-3a04-4826-ab53-01e4c7de50cb PublicKey
[6/5/2020 11:40:45 AM] System.Management.Automation.PSArgumentException: Property PublicKey does not exist at path HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\5284e747-3a04-4826-ab53-01e4c7de50cb.
[6/5/2020 11:40:45 AM] Add registry value HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5284e747-3a04-4826-ab53-01e4c7de50cb PublicKey with value [Blocked]AQAB
[6/5/2020 11:40:45 AM] Check registry value exists HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5284e747-3a04-4826-ab53-01e4c7de50cb Url
[6/5/2020 11:40:45 AM] System.Management.Automation.PSArgumentException: Property Url does not exist at path HKEY_CURRENT_USER\Software\Microsoft\VSTO\Security\Inclusion\5284e747-3a04-4826-ab53-01e4c7de50cb.
[6/5/2020 11:40:45 AM] Add registry value HKCU:\Software\Microsoft\VSTO\Security\Inclusion\5284e747-3a04-4826-ab53-01e4c7de50cb Url with value file:///C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.vsto
[6/5/2020 11:40:45 AM] ImportSigningCertificate dllPath is C:\Users\userX\AppData\Local\UiPath\app-20.4.1-beta0022\UiPath.Integration.ExcelAddIn.dll
[6/5/2020 11:40:45 AM] ImportSigningCertificate Importing SignerCertificate into the CurrentUser TrustedPublisher store
[6/5/2020 11:40:46 AM] ImportSigningCertificate - SignerCertificate imported successfully
[6/5/2020 11:40:48 AM] StartExcelAndCheckAddInConnection - COMAddIns.Count: 1
[6/5/2020 11:40:48 AM] StartExcelAndCheckAddInConnection - ComAddIn detected: ABBYY FineReader 11 MSExcel COM Add-In
[6/5/2020 11:40:48 AM] StartExcelAndCheckAddInConnection - UiPath ComAddIn not valid
[6/5/2020 11:40:48 AM] OfficeAddInSetup Error:
[6/5/2020 11:40:48 AM] Finished ExcelAddIn installation at 06/05/2020 11:40:48

Any ideas here? Trying to get past this hurdle to start using the features.

Do you have excel file on onedrive?

No, it’s local.

Can you confirm which version of Excel you have installed?

I have image

Also shows version 2005. I also see the add-in being loaded when Excel starts up, if that is of any help.

what is version 2005?

Any other problem solving tips or solutions here? Still unable to get this to work.

Is there a better way to get support? I’ve been trying to solve this for 13 days…