excel open worksheet

[analog]

Hi,

My program writes the result to Excel. Every test result has its own worksheet. Once a test is done running, it will open a new worksheet and puts data in. For some reason, I keep having extra worksheet created. For example, I ran test A and test B. Once test A is done running, in excel, I want to only have test A worksheet, but I also have Sheet 6, and once test B is done running, in excel, I want to have test A and test B worksheets, but I have test A, sheet 6, test B, and sheet 8. Does anyone knows why the extra worksheet (sheet 6 and sheet 😎 were created? I have attached the excel open new worksheet and name worksheet.vi that I used.

Thanks

[Robert M]

Hello analog,

It looks like you are passing out of your vi the reference to the unnamed worksheet rather than taking the worksheet reference out of the right side of the property node. It�s possible than correcting this will solve your problem.

If none of these suggestions help, or if I�m not correctly understanding your issue, please post a wrapper for this vi which exhibits your described behavior, and I�ll be happy to look further into it.

Have a nice day!

Robert M
Applications Engineer
National Instruments