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.