Push/write data into an unopened file
 

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

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

Undortunately, I am not a VB programmer, although very comfortable w/ Excel
functions. Is this possible with Excell formulas or basic programming?

"Duke Carey" wrote:

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