Report generation toolkit with excel 97 Graphing issue

[jdebuhr]

I am trying to set-up mu data output to use the report generation Vis. However I am running into a problem when trying to update 2 graphs on the same sheet in Excel.

My set-up is:

Windows XP

Office 97

LabVIEW 7.1.1 with the Office toolkit installed

I noticed that I can write to the first Graph and update it without issues, but once I try to update the second I get error -41105 stating that MSGraph is not installed.

I did notice that if I set a break point between the Excel Quit Graph.vi and Excel Update Graph.vi if I click the mouse within excel in removes the highlight border from the first graph, the I continue and it works fine. For some reason LabVIEW is not releasing that Graph to be able to select another.

I tried to write data to a cell after quiting the graph and then selecting the second graph but that is not working either although it does work manually.

Next I may try a Macro but I would rather not have to do that.

Any suggestions?

Jeff

[jdebuhr]

Well after some debugging I found it. Apparently for Excel 97 only there is a problem that when you qiut MSGraph it may not save properly so the VI had the Quit Property removed.

I have added it into my code and it seems to work and will see how well it does and if I run into any problems.