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

I know my answer sound strange but you can change a workbook without
opening the file. Yo ucan use a workbook like a database using the ADO
method which is really an Access database feature. You can see a lot of
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 using
SQL commands and/or creating a RecordSet to read and write data to the
file.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=187200

http://www.thecodecage.com/forumz/chat.php