Writing data to an excel file

[tammy]

I have an excel spreadsheet that that creates a chart
when the spreadsheet is opened. I am trying to pass the
chart title to a certain cell in this spreadsheet from a
form in access without having to open the excel
spreadsheet file. Does anyone know how to pass data to a
cell without opening the file?

For example, you can use the transferspreadsheet command
and it sends a table or query output to an excel file
with out opening the file. Is there a way to send the
data in an unbound field on a form?