Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Error: Data May Have Been Lost | Excel Discussion (Misc queries) | |||
How do I copy data from a cell in one file to another? | New Users to Excel | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |