Open excel sheet by sheet name .... subvi not closing

[LievenD]

Hi all,

I am experimenting with excel and labview and I want to open an excel sheet by its name.  I have created a project with a main vi where I hit a button to start the process.

When this button gets hit an event handler opens my subvi that actually asks for a file, then scans all the sheet names and then in this subvi I have another subvi that pops up and gets this sheet names.  When I hit OK this one should close and the first subvi should continue.  This all works fine and I am able to read the preferred sheet name but the subvi that asks for sheet name to read does not close.  When I run this subvi by itself then it closes when I hit ok.

I have added the whole project here so if anybody could have a look at it and tell me what I am doing wrong I would appreciate it.

Thanks

Lieven

[LievenD · Accepted solution]

Ok .... I've found the problem thanks to another post on the forum.  I changed the window appearance to dialog which solved the problem.

Lieven

[RustyStrings]

Your code helped me to make a list of sheet names, thanks