How to invoke VBA

[tombillydavid3]

Hi Supports,
After finishing VLOOKUP activities, I would like to invoke VBA in the same excel file and same sheet. But I got failed message. Where should I put the VBA activity? Will my excel file auto saved after VLOOKUPs and may I use the output file directly to VBA? Or should I change the extension for the excel file?
Main.xaml (18.0 KB)

My project provided as attached. Thank you for the great support!

[Anil_G (Anil Gorthi)]

@tombillydavid3

Can you please specify the error…also some screenshots would help as if you give only xaml we cannot open without full project most of the times and also to keep the discussion relavant adding screenshot and error details is better

Cheers

[tombillydavid3]

Hi Anil,
Thank you for the support. Screenshot of my project prodived below

And error message was in Chinese, but my UiPath setting was in English.

Invoke VBA: 用戶端中斷了已啟動物件的連線。 (0x80010108 (RPC_E_DISCONNECTED))

I think is this error happend in excel? I would like to know how should I save my VBA.
Thank you so much!

[Anil_G (Anil Gorthi)]

@tombillydavid3

Did you happen to use close excel inside your script? if so that is causing the issue I believe

cheers

[tombillydavid3]

Thank you so much for all the support!!!