Here is the answer which is answered on other post(MSDN) by S.Y.M. Wong-A-Ton
---------------------------------------------------------------------------------------------------------------
Yes, you can do it using Excel automation. See
http://www.mvps.org/access/modules/mdl0006.htm for an example of Excel
automation that opens a workbook and sets the value of a cell.
---
S.Y.M. Wong-A-Ton
---------------------------------------------------------------------------------------------------------------