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,NextAvailableCellofaSpecificRow),)

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,NextAvailableCellofaSpecificRow),)
>
> 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,NextAvailableCellofaSpecificRow),)
> >
> > Thanks