Invoke VBA - unregistered interface

Help Activities
, ,
1

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.

excel_vba1
excel_vba12064×1011 235 KB

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.

2

@Leszek_Krukar

Where is your vba stored?

Vba are generally stored in xlsm files not xlsx

And are other activities working normally?

cheers

3

Hi @Leszek_Krukar

Try with classic activity instead of modern and try again

image
image341×551 57.2 KB

Checkout this to disable modern design

Regards
Sudharsan

4

It stored outside excel file.

5

I checked this and unfortunately I got the same error.

excel_vba4
excel_vba4728×394 70.7 KB

excel_vba3
excel_vba3679×835 67.7 KB

Thanks for idea

6

@Leszek_Krukar

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

Regards
Sudharsan

7

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 !

8

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

9

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

10

Ok @Leszek_Krukar , Sad but thanks for your info!

11

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

12

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.