How to read activex control combox in excel

Help Something Else
1

Hi Team,

Please guide on how to read the values in activex control combox in excel.
We tried with OCR, sometimes it is not working.

image

Book1_Sample.xlsx (20.3 KB)

Thanks in advance!

2

Hi @Soundharya

I hope this works for you, it uses Call VBA to execute an external VBA that sets the value for the control. The VBA code can be modified on the .vb file
BlankProcess_ExecuteExcelMacro.zip (17.7 KB)

It also requires to set the trust access into the file to allow UiPath run the macro. That can be found here:
Invoke VBA (uipath.com)

Regards,
Andres Tarazona

3

Thanks @AndresTarazona, your solution helped to get the value.
Thanks a lot!!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.