topic Re: MS - Excel VBO Find or Go to Cell action action not working in Product Forum

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

shenryifds — Mon, 15 Sep 2025 15:57:08 GMT

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,

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

greggoodrem — Mon, 15 Sep 2025 16:02:10 GMT

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.

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

VanamalaSrinivas — Mon, 15 Sep 2025 16:53:00 GMT

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

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

shenryifds — Mon, 15 Sep 2025 17:18:42 GMT

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.

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

shenryifds — Mon, 15 Sep 2025 17:24:50 GMT

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

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

shenryifds — Mon, 15 Sep 2025 18:11:55 GMT

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.

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

shenryifds — Mon, 15 Sep 2025 18:56:02 GMT

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!

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

Michael_S — Tue, 16 Sep 2025 08:50:52 GMT

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