How to read data from macro enabled Excel Wizard?

[hiremathns]

Hi I have Excel sheet which is macro enabled(.xslm) which contains data entry forms ,drop down and buttons built using VBA script. Can anybody suggest best approach to read the data from the sheet apart from image/OCR automation .

[varunk (Varun Kumar)]

@hiremathns

Try this with modern activities it will work & For data entry forms we can able to do using uiautomation easily it will work

Thanks
Varun

[pavan_kumar5 (pavan kumar)]

Hi @hiremathns ,

Here using VBA with entry forms, these are built with help of user Form? If yes do one more step in VBA . For example if you are updating a value from the drop down, in VBA you have to capture and store into one variable. Similar for all. Once done these data pass it back to UiPath via argument. It will works.

Regards,
Pavan Kumar

[hiremathns]

I guess its done with some macro functionality, however i dont have access to backend VBA script, only requirement is to read data from Text controls, buttons and dropdowns from this Xslm file and update it on SfDC.

[pavan_kumar5 (pavan kumar)]

Is that protected one? If possible share me screenshot ?

Regards,
Pavan Kumar

[hiremathns]

its not protected,please find attached screenshot,