LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Find and Replace VI error

Solved!
Go to solution

Hi:

         I am using Labview2018 with Report Generation. My PC is running Win10 and has Office2016 installed. I happened to find that "Excel Find and Replace.vi"  is error.

        Does anyone konw the reason? This Vi is original.

Download All
0 Kudos
Message 1 of 17
(6,399 Views)

What does the error dialog say when you click on the broken run arrow?

0 Kudos
Message 2 of 17
(6,377 Views)

However,LV2017 has no such problems

Download All
0 Kudos
Message 3 of 17
(6,363 Views)

The problem may be caused by 32-64bits.

Office2016,64bits

Labview2018,32bits

0 Kudos
Message 4 of 17
(6,359 Views)
Solution
Accepted by zhaoqing-zhou

I reinstall Office2106-32bits,and Labview2018-32bits。

The problem get sloved。

I wish Labview switched completely to 64bits。

0 Kudos
Message 5 of 17
(6,327 Views)
Solution
Accepted by Kristi_Martinez

Just responding because I had this same problem, but do not have the flexibility to install a 32-bit version of Office. 

I was able to resolve the error by going to the block diagram and re-selecting 'Replace' on the invoke node.  This had the effect of adding another field to the node, and once that was there, the error resolved.   I had to do this for both polymorphic instances (str and num) in order to completely resolve the issue.    

Message 6 of 17
(6,050 Views)

tbilir, thank you for your answer, it is very helpful to the problem I encountered!

Message 7 of 17
(5,913 Views)

Thanks, this was a big help

0 Kudos
Message 8 of 17
(5,690 Views)

Hi,

I have installed LB2017 ,64 bit and Excel 2016 ,64 bit, I was facing the same error ,just follow your instruction, just Relink the Invoke Node that problem was solved .thanks for your update. Now able to Build a EXE file.

0 Kudos
Message 9 of 17
(5,484 Views)

I know this is an older thread, but thanks for the solution to reselect "Replace."  It worked for me.😀

0 Kudos
Message 10 of 17
(5,285 Views)