Problem with ActiveX / Excel / LV7.1 in program which worked on an older LV7.1 installation...

[davey31415]

Hi,

I have a LV7.1 program which worked when ran on an older LV7.1 installation. 

I installed Office XP and LV7.1 and can open the program with no problems.  After opening I ctrl+shift+click the run button to force a recompile and the arrow becomes broken.

All the errors I have found are the same: Invoke Node contains unwired or bad terminal.

Below is a screenshot of one of the erroneous block diagrams.  I am hoping the error is recognizable.

The only two issues I can think of are:

1. I am running Windows 7- perhaps the ActiveX does not work the same way?  I am currently installing Windows XP to see if this corrects the problem.

2. Perhaps there was an Office toolkit or something used along with LV7.1 to create this program?  If so, any ideas on what it was and where I can get a hold of it? 

Thanks,

Dave

[RDR · Accepted solution]

I am assuming the invoke node in the picture is the node throwing the error.  Have you tried right-clicking the automation refnum control on the front panel and linking to the ActiveX component.  If this resolves the issue, it was likely a case of the object model version changing.

Good luck!

-Bob

[davey31415]

Thanks Bob.  Yes, the invoke node in the picture was the one throwing the error.

I know next to nothing about ActiveX.  I right clicked the refnum control on the front panel and created a new invoke node on the block diagram (wasn't sure exactly how to link to the existing invoke node).  I rewired all the old connections and deleted the old invoke node.  Seems to have taken care of the problem.

Would the object model mismatch been caused by different versions of Offie being installed?  I was thinking about trying Office 97 as well but if rewiring fixes all the problems I guess I won't need to.

Thanks again,

Dave

[RDR]

Hmm. The version mismatch was likely due to an update to the object model, which might have been the result of installing a newer version of MS Office (updating dependencies)...  Are there any other differences between the previous installation and the new one?

-Bob

[davey31415]

Last working installation was on XP not Windows 7.  I plan to test this difference tomorrow.

I'm not certain what version of Office had been installed or if any additional LV toolkits had been installed. 

I hope to figure out what caused the problem but the important thing for today is that the issue is resolved.  Thanks much.

Regards,

Dave