Invoke VBA - device I/O error

[Karan_Zaveri]

Hello UiPath Experts,

Greetings of the day.

I am having an error in Invoke VBA activity with error message - Device I/O error. [attaching orch logs screenshot for reference]

The macro settings are also enabled in the excel application, attached screenshot for reference.

Below is the .vb script used in Invoke VBA activity [the script is stored in a text file and path is provided via config file]
Function Letter2Number(ColumnName)
Letter2Number = Range(ColumnName & 1).Column
End Function

this is a screenshot of how the activity is Setup in UiPath studio,

Please provide any solution on how this can be fixed.
Appreciate your valuable inputs and time.
Thanks

[ashokkarale]

@Karan_Zaveri,

Welcome to the UiPath Community!

Is this repetitive error? Are you able to reproduce it in DEV machine or QA machine?

If yes then only we can fix this. Check this and let me know.

Thanks,
Ashok

[Karan_Zaveri]

NO @ashokkarale don’t have error in Dev/QA only in prod.
Could you provide any details on why is this even happening?

[Karan_Zaveri]

This error is repetitive in prod, we have about 3 to 5 executions all having same error.
I also have another process that does the same operation, but that doesn’t have any error.

[ashokkarale]

@Karan_Zaveri,

That’s strange. If it’s consistently occurring error then you can retry by restarting the production machine.

There is nothing really available over internet as well.

Device I/O error - Visual Basic

Thanks,
Ashok