How to get vba message box value into uipath variable value

Help Studio
1

Hello,

I am using Invoke VBA activity where I filter file and trying to get visible cells count in UiPath variable. In VBA code message box its shows correct value, but it is not assigned in UiPath variable. Can anyone help me.

I have tried with below.

image
image1020×396 22.2 KB

Below is my VBA code.
image

2

I am not so familiar with VBA but I believe you would need to return the value of cnt then on the Invoke VBA properties put avariable for the OutputValue, then use that output for your message box.
image

3

@nilesh.mahajan

In your vba assign the rows_count value to searchinvoicenumber = cstr(rows_count)

Then the value will be given to output variable in your invoke vba
So basically to return the value we have to assign it to function name

Hope this helps

Cheers

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.