Invoke VBA - unregistered interface

I’d like to run outside macro in excel and Studio send me message about error like below.
I use excel file with xlsx extension.
The macros are enable in excel and Excel Process Scope.

It looks like is something wrong with COM:
UiPath.Excel.ExcelException: Interfejs niezarejestrowany (unregistered interface).
—> System.Runtime.InteropServices.COMException: Interfejs niezarejestrowany.

I have no idea how to repair this.
I also use invoke VBA and run macros in other projects and it’s working fine, but these projects are in older version of Studio. Now I use version 2022.10.4 and VBA doesn’t work.
Please send me any ideas.

@Leszek_Krukar

Where is your vba stored?

Vba are generally stored in xlsm files not xlsx

And are other activities working normally?

cheers

Hi @Leszek_Krukar

Try with classic activity instead of modern and try again

Checkout this to disable modern design

Regards
Sudharsan

It stored outside excel file.

I checked this and unfortunately I got the same error.

Thanks for idea

@Leszek_Krukar

Save the file in .vb intead of .txt and try again one
image

Regards
Sudharsan

I tried and result is the same.
I tried to use Invoke code with Excel namespace and it appeared the same problem.
I discovered that I have a problem with COM Microsoft.Office.Interop.Excel.
The Visual Studio and UiPath don’t see Excel namespace.
I’m still fighting, thank you !

Did you solve this problem? I am also facing the same issue here!

Unfortunately not. I don’t want to reinstall whole system and UiPath.
Greetings

Ok @Leszek_Krukar , Sad but thanks for your info!

Did you resolve this issue? I am facing the same issue as well.

Hello,

So one of the first things that I would try when facing a COM issue is running the repair tool :slight_smile:

Other things that would come in handy for us in order to help you would Excel version , packages version ( from the print screen attached I can see that you use Excel 2.16.0 ) and if possible logs and a helper project. I say logs because usually COM exceptions do come with an error code attached and that is helpful for us to try and decipher the old and forgotten language of COM :smiley:

Regards,
Dragos.