cancel
Showing results for 
Search instead for 
Did you mean: 

How to get location from "MS Excel VBO-Find in Worksheet"

jiyeon_gim
Level 3

I'm trying to use "MS Excel VBO-Find in Worksheet"
But I find out it can only export Success(Flag), Message(Text), Matches(Collection).
Is there anything that I can do to get the location of the search text?

jiyeon_gim_0-1743048167275.png

I downloaded this VBO from Blue Prism Digital Exchange.

https://digitalexchange.blueprism.com/dx/search?keyword=%22Blue%20Prism%20Enterprise%20-%20Core%22&page=1

 

2 REPLIES 2

Michael_S
Community Team
Community Team

Hi @jiyeon_gim - just to let you know, I've moved your question to our Digital Exchange forum where you're more likely to get a helpful answer about VBOs.

Hi @jiyeon_gim 

Normally  in the marched coolection you will have all your needs 

See example below : 

i am searching Spencer here : 

Mohamad_747_0-1743282191377.png

When i use find in worksheet i provide this : 

Mohamad_747_1-1743282250209.png

and then in the matched collection i will have this : 

Mohamad_747_2-1743282279361.png

 

So it give me the correct location.

Is that anwser your request or you need more details ?

Dont hesitate