MS - Excel VBO Find or Go to Cell action action not working

[shenryifds]

Hi Everyone, 

I have a process in which I'm trying to locate a call by either using the Find or Go to Cell actions from the MS - Excel VBO. 

For some reason I keep getting an error message or that there are no results. 

Was looking at the documentation but doesn't say anything special. 

I would think simply entering the string to locate is enough, but I feel I am missing something. 

Trying to understand what I'm doing wrong here. 

I'd get the same result if using the Go to Cell action. 

Thank you, 

[greggoodrem]

If you have two different VBOs for Excel we often have these issues. Check you’ve not opened with one VBO and then trying to use an action from another. 
You can in the extended VBO attach to this instance and use any of the functions. 

[VanamalaSrinivas]

Hi @shenryifds,

Try to give the worksheet name as well as i see in the screenshot there is no worksheet name.

Also before this 'Find' try using 'Activate Worksheet' and give a try.

Thank You 
Srinivas

[shenryifds]

Hey there, 

I've also ran into this issue in the past as well but in this case I'm referencing the same VBO across all actions. 

[shenryifds]

Hello, 

I am activating the worksheet before trying to Find my cel.

I also just tried with the Worksheet Name but getting the same error. 

If I try using the "Get Cell Value" action I get an internal error. 

Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC

Looking at my Excel, I don't see anything that stands out. 

Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC

[shenryifds]

Correction here, apologies. 

The other action I was trying to use was not "Get Cell Value" it was "Go To Cell".

What I was doing wrong here was not providing a valid cell reference like A12, for example. 

[shenryifds · Accepted solution]

Hey Everyone, 

Another update here. 

I got it to work but seems I need to include the Range parameter.

Once I provided this it worked. 

Thanks everyone! 

[Michael_S]

Nice work on this one everyone, and congratulations on getting it fixed @shenryifds 💙