Excel problem

[Gatet]

When LabVIEW is using Excel, this crashes if u write in another sheet (for example, making a graph  or writing a formula from the previous results). Is possible to solve this problem, giving a kind of priority (or something like that) to ActiveX?

Thanx in advance

[xseadog]

Hi Gatet
Q:Do you mine a sheet in same workbook or another workbook ?

We have  a similar problem with a visual basic application(that will eventually be  translated to Labview)
Our solution at present is to allow the logging application to  finish before writing in associated sheet.

Are you using excel toolkit  or activeX ?

Chow
xseadog

[Gatet]

Hi, Xseadog.

The problem is either in the same or in another workbook, It would be nice to solve it at least for different workbooks. And we are making use of ActiveX functions to manage it.

How can u give the logging aplication privileges? Another point is that is hard to wait until the process is finished, cause the measurements (and its respective Excel writings) can take hours...

Thanks for your time.

[xseadog]

Hi

 Have you tried to open another excel application  and use that at the same time. Our problem occurs in the same workbook were

we try to 'open' an other sheet which the application uses to update screen etc.

Possible idea would be for application to dump data to text file,  every 15 minutes dump to new text file so that possible to analysis

data whilst logger records cyurrent data. The15 minutes is just an arbitrary value.

chow

xseadog

[Joe_H]

Here are some vi's that might help you all out, not sure what the problem is though because I have never experienced it but I will look into it

[Michael_Munroe]

It sounds like you are trying to use Excel to perform analysis of the incoming data while the data is being logged.  ActiveX control is immediately disabled when any changes are made to any Excel object on any worksheet of any workbook.  Control will resume when the editing is complete.

I recommend that you include the analysis in an Excel template and log the data in another worksheet.  Log your data to Sheet1 and create charts for analysis in Sheet2. Just provide ranges for the chart to include the whole column of the source (ie. Sheet1!C:C).  Every time you view the chart on Sheet2, it will be updated to show all data collected. 

 You can also create your chart in another workbook, reference the logging workbook and open the second workbook before the data collection begins.  If you regularly write the data to disk, just open the workbook READ-ONLY from another computer on the network to perform analysis of the snapshot.