Invoke VBA: Interface not registered

[rahul.arade]

Whenever I try to perform macros on excel using invoke vba activity , I m getting this error “Invoke VBA: Interface not registered” . please help me I did not got any solution anywhere.

[Srini84 (Srinivas Kadamati)]

@rahul.arade

Welcome to forums

Can you check below for your reference

VBA interface

Hi @Saikiran_K , Try with reinstalling office with trouble shoot steps with the below attached document, UiPath Excel Addin Installation Troubleshooting v4.docx (388.6 KB) For more informations check this below link, Hope this may help you

Hope this may help you

Thanks,
Srini

[Anil_G (Anil Gorthi)]

@rahul.arade

Welcome to the community

Go to settings in Excel and go to trust center settings and enable all macros and external vba

cheers

[rahul.arade]

I have done all this settings but still getting same error

[Anil_G (Anil Gorthi)]

@rahul.arade

Can you try to reinstall office if that might fix…Also try changing the excel package version and check fi that helps

I dont see any other issue currently …are you able to run macro from excel file directly?

if yes then try creating a xlsm file with required macro and use that to do your manipulations

cheers

[rahul.arade]

ok i will check …

@Anil_G Thank You So Much

[Gonzalez_Edwin]

Hello Rahul.
Were you able to find a solution to this. I recently migrated one of my automations to windows and this activity has stopped working. When it was in legacy it worked perfectly and I didn’t have any issues. Hoping someone can help me out with this, the VBA is important for my automation.