Others with more tricks than I may have a simpler solution for you, but to
write to a closed file I think you need to use VBA, connect to the file with
ADO, and use SQL commands to write to the file.

"Rod" wrote:

Does anyone know how I can write data into a specific cell of a closed file
from an opened file, e.g.
If(true,Write(FileName,NextAvailableCellofaSpecifi cRow),)

Thanks