topic Re: Invoke VBA to Update Excel Combo Box in Product Forum

Invoke VBA to Update Excel Combo Box

RossMcDonald — Thu, 08 Jun 2023 15:50:31 GMT

Hi,

I am trying to convert a piece of existing UiPath code into BluePrism.

The old UiPath code would invoke VBA code from a .txt file in order to update a combo box value (see below for the code)

Sub UpdateComboBox(InputString as string)

ThisWorkbook.Sheets("Sheet1").ComboBox1.Value = InputString

End Sub

Is it possible to run a VBA Macro from a .txt file using Blue Prism or is there another easier way to implement this code using a Blue Prism code stage?

I'm not able to create macros inside of the excel spreadsheet which I know would be an easier solution,

Any and all help would be much appreciated!

Re: Invoke VBA to Update Excel Combo Box

_Amlansahoo — Fri, 09 Jun 2023 04:43:19 GMT

Hi Ross MCdonald,

With latest MS Excel VBO from blueprism there is an action to invoke VBA using .txt file. Please try to use that.

Here is the link for the same https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Re: Invoke VBA to Update Excel Combo Box

RossMcDonald — Fri, 09 Jun 2023 09:58:46 GMT

Thanks Amlan Sahoo, unfortunately I'm getting the error of "The macro may not be available in this workbook or all macros may be disabled"

I've checked that Macros are enabled in Excel so I think it's a different issue, please see the below for the various settings and code I'm trying to run.