Inject VBA activity

Help Studio
, ,
1

Hello everyone,

I am currently trying to inject some VBA code into an xlsx file to alter the formatting.
I have the vba code saved in a text file, but when I go to run it comes back with an error
Invoke VBA: Cannot execute macro 'WrapCells'. Macros may not be available in this workbook, or all macros may be disabled.

the code

Sub WrapCells()
    With ThisWorkbook.Sheets(1).UsedRange
        .EntireColumn.NumberFormat = "@"
        .WrapText = False
    End With
End Sub

When the code is invoked from UiPath however some encoding error appears
before Sub WrapCells()
after ・ソSub WrapCells()

some background information
Using Excel in Japanese.
Using UiPath in English, 2023.6.1 Community Edition.
Using Classic activities.
All the settings to allow macros are enabled.
I also added the location as a trusted folder.

any ideas would be appreciated.

Thank you

2

@xdasda_asdasd

Can you please show how you are trying to invoke…some screenshots might help

cheers