LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

'write to spreadsheet' VI error: File already open

Solved!
Go to solution

 


Ravens Fan wrote:
Perhaps when you get the error, store what you were going to put into that file into memory or a temporary file.  Pop up a dialog that doesn't halt your program telling people not to open the file.  When your program detects the file is no longer open giving the error, then write out all that you stored in memory (or read from the temp file and write it out) before appending the newest data to the file.

 

 

If it's an error during the store, I'm pretty sure that my work around for that solution was to change the write permissions of the file - i.e. detect if the file is not writable and change it to writable if it isn't - this means no operator dialog box - of course you will probably always want to read the info into memory at the start of the program (or as early as possible) anyway to give you the option of storing to a backup hardcoded file location.

 

James

CLD; LabVIEW since 8.0, Currently have LabVIEW 2015 SP1, 2018SP1 & 2020 installed
0 Kudos
Message 11 of 11
(426 Views)