Excel-ActiveX-Maximized if I close it, I get missing reference error

[karthik9]

I have report which is generated  using excel(not Report genration Toolkit).... There is an option for window state.

Well I want it open,(but the problem is if someone closes the excel file, I get errors saying no reference... and all that thing)

Is there a way to view this way(i.e. updates while entering and does not cause problems if we close it)

[GerdW]

Hi karthik,

you need to program some error handling.

When your user is able to close the excel workbook while your program is working with it, you need to check for errors. When an error like "missing reference" is popping up you need to re-open the workbook…

[karthik9]

No If you reopen wouldn't the reference be something new.... wouldn't this cause the old data to vanish???? And If I do error checking I have a huge amount of formatting and other stuff going on and the data that comes should not get misplaced for the error checking.... I think i'm screwed right

[Munna232]

Check this ,

I hope this will help you.

http://forums.ni.com/t5/LabVIEW/Open-EXCEL-at-Runtime/td-p/2906890/page/2

[karthik9]

Well I Got to open the reference , but how do I get the old data back,,, I periodically store it in the had-drive.... but how do I like make it to continue from that point.... I've no idea how to create a reference for an existing Spreadsheet file or copy the spreadsheet file into a new Reference

[karthik9 · Accepted solution]

Oh well! I found a way to solve that roblem just use the Stored file name as the template while creating the  New Report!!! Thanks