10-05-2013 09:03 AM
Hai
I have used MS OFFICE REPORT from report generation toolkit & MS office Excel 2007. Every day Report Should generate automatically. i am using template in
the form of'.xlt' . & saving file is in the form of '.xls' .So at the time of report generation ms office checked 'Compatibility checking' for saving report. so my labview program wait for the dialouge box anwer to give manually.so i Can't generate report automatically. i am facing this problem for 2 days .Before that Reports are generated properly(At the time Ms Office not check Compatibility). Pls GIVE SOLUTION ASAP.
Regards
Vinoth
10-05-2013 11:55 AM
Without more information, it is difficult to offer advice. Here are some questions:
I haven't use Excel templates, but I do open existing Excel (.xls) files, modify them, then close/save them. [If I wanted to open "Master Excel File.xls" as a model file, but save it under the name "My Excel Output.xls", one easy way to do this is to use the ordinary LabVIEW "Copy File" function to copy Master Excel File into My Excel Output, then use the latter in my program]. Here are snippets showing how I open an existing Excel file, and how I close/save it. Note that I need to maintain the Excel Object wire intact as I add other Report Generation VIs to do the Excel reading and writing.