Push/write data into an unopened file

[Rod]

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

 

[Duke Carey]

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]

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