I am new to Nintex RPA and trying to create one bot which starts by openning a workbook. Once I try to run the script, the action "Open Workbook" give me the following error: "Error 13: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with ID.....failed due to the following error: Element not found. [Exception from HRESULT: 0x8002802B [TYPE_E_ELEMENTNOTFOUND]]." [see attachment].
I tried with different workbooks and only with this action. I am using local version of Excel of O365.
This is a notification for product news or an alert. If you have a question, please start a new discussion
Posted By Bennie Pienaar 6 months ago
Learn how to fix the ‘Unable to cast COM object of type Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type..’ error exporting Document Type record, in Sage 200 Evolution.
Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl'
Posted on by75
Hello!
I hope you can enlighten me on this.
I am trying to call all 'case categories' and 'category types'. Basically what you see here:
I'm trying to get something similar to the 'Case category' field to appear. But when trying it I get the following error:
Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl'.
I understand that the error occurs when trying to convert the 'String' to the data type that belongs to 'Case category'. But I have created my field with the same properties as the original, and in the 'Category types' I have no problem calling it. I want to know if anyone knows how I could solve this.
Here's an example of the form I'm designing:
[View:/cfs-file/__key/communityserver-discussions-components-files/765/2500.AX-365-on-DESKTOP_2D00_D03BVN5-_2D00_-Virtual-Machine-Connection-2022_2D00_05_2D00_05-09_2D00_49_2D00_52.mp4:320:240]
- RE: Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl' I have achieved my goal, and indeed, the error was due to the data type. What I have done is to create in my table a field of type 'Int64' that will store the 'RecId' of the record of my parent table. I have created the corresponding relationship and in my form I have added both data sources, I set the 'Join Source' property of my data source to 'CaseCategoryHearchyDetails' which is my parent table. After that I created a Reference Group. Here is the process I followed: AX / D365FO – Cómo usar el grupo de referencia en un formulario en AX 2012 – Blog de AX / Dynamics 365 For Finance and Operations [d365ffo.com] Here the result: [View:/cfs-file/__key/communityserver-discussions-components-files/765/AX-365-on-DESKTOP_2D00_D03BVN5-_2D00_-Virtual-Machine-Connection-2022_2D00_05_2D00_05-12_2D00_09_2D00_24.mp4:320:240]
- RE: Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl' No, I don't add any method. I was investigating, and it seems that the field that I want to use is a reference group, and from what I could see, it is made with a relationship to the parent table, which I relate to the 'RecId'. I will try to follow this logic and tell you how it turns out.
- RE: Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl' Info is a class, therefore either expand Code > Classes node in AOT and find it there, or use a filter in Application Explorer [e.g. ^Info$ type:class]. Open the class in designer, put add in the Search box and the select the add method in the filter list. Double-click it to open it in code editor and that's where you can add a breakpoint.
- RE: Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl' Hi MarcosAP25, As per Martin's suggestion, You can place a breakpoint in add method in Info class. From the video you have shared, it looks like the error is getting triggered when you try to perform lookup. Do you have any code in the lookup method?
- RE: Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl' But, where can i find the 'Info.add[]'??
RE: Unable to cast object of type 'Dynamics.AX.Application.FormStringControl' to type 'Dynamics.AX.Application.FormReferenceControl'
A good course of action would be finding where the error is thrown. You can, for example, add a breakpoint to Info.add[], debug your code amd look at the stack trace.