Prime 4 and Office 2007: I have an excel file open and can read it using the READ function.
BUT it only reads what's in the file. So the actual situation in the Excel application is not reflected until the file is (re-) saved from within Excel and I recalculate the region in Prime.
The situation is non-existent when there's no Excel application in play, e.g. if you create the excel file from within Prime and (also) read it from within the same sheet in Prime. There is no function to 'close' the excel file. Every WRITEEXCEL() call opens the file, potentially modifies the file contents and then closes it. You cannot stream to the file as far as I know.
If you're reading from and writing to the same excel file from two different sheets within Prime, you're essentially back to the first paragraph of my answer: Prime only reads what is saved to the excel file...
Success!
Luc
