Using Invoke VBAX gives an error: Error opening workbook. If Excel is installed, run the 'Repair Tool for Microsoft Office Interop' from the Tools tab on the Home screen

Help Activities
, ,
1

I’m getting an error on a remote machine when trying to use the activity: UiPath.Excel.Activities.Business.InvokeVBAX to run a Macro code that adjusts the column widths, and headers in a workbook. I’m using this activity inside UiPath.Excel.Activities.Business.ExcelApplicationCard which is inside UiPath.Excel.Activities.Business.ExcelProcessScopeX

UiPath.Excel.Activities.Business.ExcelProcessScopeX
– Launch method: Automation
– Macro settings: Enable all
– All other properties: Default

The activities run fine on my machine. It didn’t earlier but I configured a setting in Excel which made it work on my machine. (Excel > Options > Trust Center > Trust Center Settings > Macro Settings > Under Developer Macro Settings, check “Trust access to the VBA project object model”)
But when I made the same change on the remote machine, it did not work.

Excel package version: 2.24.3

My machine details:
Windows version: Windows 11, 22H2, 22621.4317
UiPath version: 2022.10.7
Excel application version: Version 2308, Build 16731.20822

Remote machine details:
Windows version: Windows 10, 22H2, 19045.2011
Excel application version: Version 2308, Build 16731.20822

I’m thinking it may have to do something with the Excel version installed or some OS / O365 / UiPath Excel version incompatibility because the same setting worked on my machine (ran from UiPath Studio) but did not work on the remote machine (ran from UiPath Assistant).

Would appreciate any help on how this can be resolved!

Thank you,
Vasundhara

2

@vasundhara.sharma,

You will have to repair the office setup. Follow this thread for more information.

ttps://forum.UiPath.com/t/use-excel-file-error-opening-workbook-if-excel-is-installed-run-the-repair-tool-for-microsoft-office-interop-studio/724820/11?u=ashokkarale