We have a scenario where we want to read the data and fill the from ( The from is developed in Excel). WE have n number of checkbox which needs to be checked based on the data we get however checking checkbox inside the Excel is not working we tried with Anchor based , image based and normal selector. It works sometime when Excel is opened. but when we use Excel Application scope it doesn’t work.
For the checkbox, you need to right click on that checkbox and the open properties, in that there will be radio button to Check or Uncheck that checkbox
when i check the excel below is the VB code , I tried to execute the macro but it is not working and i am getting an error that macro is not available. Then i try to invoke VBA code then also i am getting an error object required. Below is the VBS code
As a simple work around did we try with HOT KEYs using SEND HOT KEY activity
It will work for sure but the thing is we need to use right number of and combination of keys to access those check boxes
Give a try checking those boxes with just your keyboard and get the keys to be used
Follow the same pattern with UiPath activity as a sequence
It will work for sure
The reason why hot key may not be that efficient as there is 50-60 checkboxes in the same sheet. and we need to perform an operation in all those checkboxes. It is a form which is developed inside an excel. Any other option we do have ?
That’s what i have done , WE can’t add new macro in the excel file as the file is coming from business thus i have copy the vba code which is written inside the excel(.xlsm) and save it as vbs file in uipath project. I call this vbs file against the excel but it is throwing an error saying object is required.
