VBA in XLSB files

Help Robot
,
1

Hi Team,

Is there a way to Apply Macros through the Invoke VBA activity for XLSB files ?

Currently Invoke VBA supports XLS and XLSX files. I need to apply macros on XLSB files.

2

@Ishan_Shelke

you can try having a dummy excel of type .xls or xlsx and in the vba itself directly open the xlsb file and work on it and close it before the end of vba…

cheers

3

Hi

Is it possible directly the answer would be No, as there is no way to apply macros through the Invoke VBA activity for XLSB files. The Invoke VBA activity currently only supports XLS and XLSX files.

But u can do with some workarounds like

  • Convert the XLSB file to XLSX format
    Try with this UiPath marketplace component for conversion
  • Then we will be able to perform the invoke VBA there

Hope this helps

Cheers @Ishan_Shelke