It uses the Sql UPDATE functionality, therefore it updates cells. If you
want to add a new value to the current value in a cell then you would need
to obtain the current value, add the new value and then update the target
cell(s).
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"George Nicholson" wrote in message
...
Andy:
Out of curiousity, do those allow you to actually "add values" like the OP
asked, or just change/update existing values?
--
George Nicholson
Remove 'Junk' from return address.
"Andy Wiggins" wrote in message
...
You can!
.. and here's how:
http://www.bygsoftware.com/Excel/SQL..._using_sql.htm
Using an UPDATE query in SQL.REQUEST to change values in closed
workbooks.
How to COUNT data in an Excel table and in an MsAccess database using
SQL.REQUEST.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"Peo Sjoblom" wrote in message
...
You can't
Regards,
Peo Sjoblom
"Ali" wrote:
Hi, if someone can please tell me how I can add values to closed
excel
file
from an open excel file. What needs to be done here.
Thanks.