Report Generation Toolkit Error

[AJL]

I  have an application that generates multiple excel spreadsheets each containing a table and four graphs.  This has been working fine for three months but I am now getting error when generating the reports.  The source of the error is in the Excel_create_workbook as indicated on the attached picture.  I am passing in a template name for my excel reports.  The error code (-2147352571) states a type mismatch.  The file path to my template is a constant so I can't see how sometimes I get a type mismatch and other times I don't.

Any help on this would be greatly appreciated.

Thank you,

AJL

[GovBob]

Not sure this will help but worth a try. Since you have a coercion dot on your template input, wire the path control through a To Variant function (from activex pallete) to that input.

Hope this helps

[AJL]

Thanks for the reply, however, this VI is part of the Report Generation Toolkit so I don't want to have to modified NI's code if possible.  I did try your suggestion without saving the VI and I still got the same error. 

Any other ideas? 

BTW - I encountered this problem first in an executable but have since seen the error in the development code.

Does anyone know if there is a limit to how many times you can create an excel document from LabVIEW?  I wouldn't think so but the error seems to happen if I try to create several (more then five usually) documents at a time. 

Thanks in advance

AJL