Updating Excel Shared file

[alex b.]

Hi,

We have an Excel file, which is in Shared Mode, that we update when specific tests (automated in Labview) are done. Now, when we do it manually, it goes fine because multiple persons can access the file and modify it, save it, and Excel manage to merge the changes of everybody.

I tried to automate the report update at the end of our tests (see vi). However, if we follow this sequence:

1) Person A opens the file

2) The automated saving is done

3) Person A saves its modifications

The changes from the automated saving are lost... Is there any way to do what I am trying to do?

Thanks

Alex

[Will_S.]

Hi Alex,

This is very possible. Based on your screen shot, it looks like you are opening the document in LabVIEW, writing to the file, then saving it as a new document(update.xls). You then copy this new document to your original folder and replace the shared file. Because you are replacing the shared file, Person A has one copy of the file in his memory, where the one in the folder is a completely separate copy. Therefore, when Person A saves his changes he overwrites the copy created in LabVIEW and so you lose your data.

The Dispose Report VI you use at the end of your code should have a "Save Changes" input. If you wire a True constant to that input and remove your Save and Move functions, it should work properly.