Open Specific WorkBook.vi: subVI is not executable error

[Daniel Coelho]

Hi,

I'm trying to programaticaly change some cells of a specific worksheet and then saving it on a new file.

But I can't run the VI because I get the error Open Specific WorkBook.vi: subVI is not executable.

I've atteched a printscreen of my VI.

Any hints?

Daniel Coelho

[RavensFan]

Are you able to open up the subVI that is not executable to see what errors it may have?

Since this is working with Excel, and it's ActiveX based.  I am guessing that the ActiveX implementation isn't exactly matching in the subVI from whatever PC it was written on compared to your PC.  Such as a different version of Excel between the two PC's is being used.

[Daniel Coelho]

This is the Open Specific WorkBook.vi with the error.

[RavensFan]

That screenshot doesn't provide any more real information than the picture in your first post.

If you click on the broken run arrow, what does it say?

The problem will probably be in one or more of those subVI's (open excel, open book, open sheet, cell value, ...)

[Daniel Coelho]

I'm sorry if I'm not being clear.

The error list only says:

SubVI 'Open Specific WorkBook.vi': subVI is not executable.

[RavensFan]

Okay.  I see now.  I missed the part that open specific workbook was the same subVI as "Open Book".

Are you saying that you get the same error message even when you click on the broken run arrow within the subVI?

Try right clicking on the Excel._Application control reference in the subVI.  Pick Select ActiveX class.  What does that point to?

[Rupali]

Hello...

Try to provide "error in(no error)" to the input of "open excel"... Just try it... 🙂

Best luck.. 🙂 

[Daniel Coelho]

The subVI Open Specific WorkBook.vi (Open Book) has the error:

Invoke Node: contains unwired or bad terminal.

The control reference points to Excel._Application.

These subVIs are from ...\LabVIEW\examples\comm\ExcelExamples.llb. I am using them as they are, I've not changed a thing.

[Daniel Coelho]

I'm not sure I understand your line of thougth.

The error cluster is connected.

[Rupali]

But it's working fine for me...  do you want me to post the same VI...?