Save

S

sarndt

In code, is it possible to set a worksheet to do a save when a cell value
changes but only do the save for the cell - not for the full
worksheet/workbook?
 
J

joel

The answer is NO from excel. Excel write the entire file when a sav
is performed. the only way you can save one cell at a time is if th
workbook wasn't opened.

I know my answer sound strange but you can change a workbook withou
opening the file. Yo ucan use a workbook like a database using the AD
method which is really an Access database feature. You can see a lot o
posting using the ADO method or look at the VBA help in Access.

The ADO mehod make a connection to the file and then make changes usin
SQL commands and/or creating a RecordSet to read and write data to th
file.
 
Ä

Ä°lknur Ates

Without copy paste all the values in another sheet, you couldnt save only the
cell.

"sarndt":
 
Top