Dynamically write data to an open file in a different sub vi

[Carnot]

Hi,

Is it possible to open a file to write data in one sub vi, pass the ref num to that file to another sub vi and write data to it in append mode ?

Cheers,

Carnot

[Dennis_Knutson]

The simple answer is yes. Why do you ask? Are you having some sort of problem?

[TiTou]

Well... why not ?
It seems like the answer is included in the question ? Have you tried ?

You can either let the file open and pass the refnum, or close the file, pass the path and re-open in the sub VI...

[Carnot]

I'm opening a spreadsheet in Excel in one sub VI and then writing data to it in another sub

VI using the refnum within a While loop.  At this point I'm getting "An input parameter is

invalid." error.

There's no error when the While loop is not there.  The error is the same if you were to pass the

refnum across two frames of a Flat Sequence.

Cheers.

[chrisger]

hi there

please post some code so we can have a look at it.

best regards

chris

[Carnot]

Hi,

Here's the code where I'm using two frames (which is equivalent to two sub vis executing one after the other).

Cheers.

[chrisger]

hi there

please see the attachment. you have to close the file only ONCE after you are done with it. when closing the file in each cycle you get the error you mentioned after trying to write to the file after it has been closed. please read the comments i added to the vi.

.

[Carnot]

Hi Chris,

Thanks for that mod code.  I was closing the file in each iteration of the while loop by including the Close File function within

the sub VI.  That might have been the one causing the prob, yeah? 

Regards.

[chrisger]

yeah.