XLR8 : Which Refs to use for Close Workbook when using an Excel template and saving to a different file ?

[asnuaaron]

My LabVIEW code opens an Excel template and saves it to a new path / filename using a modified version of the example vi "exmpl_WR_template_results.vi".

I am assuming the 'Close Workbook.vi' is trying to close the template file I noticed that the file Refs between opening the template file and closing the template file are different (the Refs are changed by the 'Save Workbook.vi' which is saving to a new file).  Please see probes 6 and 7 on the attached screen shot.

Is this correct ?  It seems like the 'Close Workbook.vi' is closing the new file rather than the original template file.

Should the 'Open Create Workbook' Refs Out be connected to the 'Close Workbook' Refs In ?

Thank you very much

Aaron

[JensG69 · Accepted solution]

Hi Aaron,

the VI "Save Workbook.vi" closes all .NET-References that were opened and created during the opening of your template file. After that the newly saved excel file is opened again and loaded into memory.

Regards,

DATA AHEAD

[asnuaaron]

Thank you Jens.