@MGarry wrote:
Hello,
I've posted my question in the french forum and i didn't get any answer, i don't know why, so i'm re-posting here.
The situation is that i have an Excel file (see attached file) and i want to get each cell from each row filled with the appropriate mesure that comes from a sensor every hour and saving the file without closing it, with the possibility of entering some values manually (setpoint values). I have LabVIEW 8.6 and i want to know if it is possible to perform this with, if so i'll be glad if you could provide me with more informations.
Thank you,
MGarry
This is all possible using ActiveX (and possibly .Net but I have always used activeX). The tricky part is if after they change things manually, detecting this in your program. I'm assuming if something is manually changed you will want your program to know about it. There may be a callback you can use, but I'm not sure. Another thing you will want to do, since the workbook could be open and manually updated, check if the workbook is already open and if it is get the reference to it. This is a little different then just using the Open Workbook funciton, because that will error out I believe. This is all from memory, as it's been about a year since I did anything with Excel ActiveX. I have an example of how to do this but I don't have the code on this computer. It's something I can post Monday.
I suggest looking at ActiveX examples and definitely check out the report generation toolkit if you have it. You may have all teh funcitonality available in it that you need.
