Thank you for attaching your code. I think I can explain all of your problems without even trying to execute your code to "see for myself".
You report two types of failures.
- You use New Report to open the RGT and read an existing Excel file in as a Template. You state that if you run this on a PC that has Excel 2016 installed, it works, but if you run it on a PC with only Excel 2013, it fails. What I think is happening is that the Template file is written in Excel 2016 or higher, and that Excel 2013, by itself, cannot open it. This is not LabVIEW's fault -- you asked LabVIEW to "ask Excel to open a file that it cannot open", and it returned an Error.
- You use New Report to open the RGT, read an existing Excel file in as a Template, use ActiveX to export it as a PDF, then open Acrobat. You state that this works with Excel 2019, but fails to generate the PDF in Excel 2016. Note, however, that it does not fail at the step of opening the 2016 Template, suggesting that my explanation for Failure 1 is correct. This is a similar case of your asking LabVIEW to ask Excel (2016) something that it has not (yet) been programmed by Microsoft, namely to output directly to Acrobat, to do. Again, this is not LabVIEW's fault.
Here is a suggestion -- try to write a little VI that can query Excel and determine its Version. You already know that you need at least "Excel 2019" (I've not kept track of how Excel versions are named, but that's the name you used ...) to get the full functionality you need, so you can at least pop up a dialog box when your program starts to say something like "Sorry, this Program requires a current Version of Microsoft Excel in order to generate Reports".
Better yet, you can eliminate Error 2 by simply not saving the Report as a PDF, but saving it as Excel, and letting the User print (or otherwise output) it in whatever format she/he wants.
As for Error 1, I recommend that you "trap" the Error (use Clear Errors with that particular Error number as its "Error to Clear"), and if you see this Error, pop up a Dialog Box telling the User that he/she needs to open the Template file and save it, which (I hope) will save it in the existing Excel format. Of course, if you provide an Excel 2016 Template, and the User cannot open it in Excel 2013, well, that's another problem. Suggests that if you are providing the Templates, you take the responsibility for using the oldest Version of Excel that is reasonable (like 2013?) to avoid this problem.
Bob Schor
