Invoke VBA: Interface not registered

Help Community
,
1

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.

1 Like
2

@rahul.arade

Welcome to forums

Can you check below for your reference

Hope this may help you

Thanks,
Srini

3

@rahul.arade

Welcome to the community

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

image
image1443×720 55.2 KB

cheers

4

I have done all this settings but still getting same error

5

@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

6

ok i will check …

@Anil_G Thank You So Much

1 Like
7

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.

1 Like
8

Facing the same problem as Gonzalez. The same macro that works in legacy project is not working in windows project.
I had to create an xlsm sample file, where the macro is saved and “Execute macro” is used + the macro itself saves the file as xlsx (as xlsm is not an option for the process). Not an elegant workaround, but at least it works. But there could be situation, where sample file cannot be created/used upfront.

I read in other forums that writing the same macro into another text files sometimes solves the problem, but for me, it was not working.
Would be happy if we would have some guidance from the support team what has chnaged in the invoke VBA in windows projects or what the new requirements.
Cheers!