Hi All,
Unit4 Excelerator is already installed in my Excel. But, when I tried using Excel automation to perform actions on Unit4 excelerator, I could not find this option in Excel. I am using modern activities( Use Excel) to open excel.
But when I open Excel manually, I can see the Unit4 Excelerator.
I have also tried with classic activities, same issue
Can anyone please help me to resolve this issue?
@rnahasnahasuddin
Modern Excel (Use Excel) in UiPath runs Excel in a background, isolated, COM instance.
This instance does NOT load third-party Add-ins such as:
So UiPath cannot “see” or automate buttons from Unit4 Excelerator because the add-in is not loaded in the background Excel instance.
When you open Excel manually, it loads your full profile → so the Unit4 Add-in appears normally.
Solution for these issue is you can open the excel and make instance visible and perform ui actions to achive goal
Is there required any action in Use Excel properties to change?
use excel process scope activity around the use excel file and in launch method property select application
cheers
@rnahasnahasuddin Yes Mak instave Visible Set True
@rnahasnahasuddin Check the Keep Excel File Open Property
I tried, but still I have the same issue
@rnahasnahasuddin as i mentioned you cant use the option as it was third party insted of that you can opne the excel file and perform Ui Automation on Excel to acive the goal using click and type into
@rnahasnahasuddin Open the Excel File and Click on Unit4 Extencion using Click Activity to perform the action
I didn’t get it properly. So you are mentioning like I want to add UI actions in code to enable Unit4 Excelerator, right?
@rnahasnahasuddin ok let me guide you step by step can you share the Screen Shot of Excel File and the Option you want to perofm(Unit4)
Hey COM-opened Excel does not load any third-party add-ins, including Unit4 Excelerator, so it will never appear inside Use Excel File or ExcelProcessScope.
To use Excelerator, Excel must be launched as a normal user-session application using Start Process (excel.exe) or Open Application, and then you must automate it with normal UI automation.
Modern Excel activities cannot load Unit4 Excelerator, so switching properties will not fix it — the only working approach is opening Excel normally and using UI Automation.
May I know what you are trying to do after the file and the addon are loaded?
If you want to open the excel file and then do some Ui operations like Click on any menu items or something, you can use Start Process activity like this:
First property value will be Excel.exe file path. For me it was - "C:\Program Files\Microsoft Office\Office16\EXCEL.EXE"
Second property will be your excel file to open - your\full\file path\with.xlsx
Added delay of 5 seconds as the start process won’t wit till the process start.
@Ruhi_Sayyad Thanks For update @rnahasnahasuddin As suggested use Open Application insted of Use excel File and the Unit4 Extension will be visible and Perform Click activity and do further action you have to perform
Yes, I have used Excel Process Scope activity outside Use Excel activity
you need to select lauch method as application in the prowprties and have excel file visisble property also turned on
cheers
