transferspreadsheet or output action

Sue R · Nov 30, 2008

Is there a way to write to a specific excel cell (ie F19), with the
transferspreadsheet or output actions? I am also trying to do this
programatically?
Help! Everything just goes to the first columns and rows. I am going crazy...

Ken Snell \(MVP\) · Nov 30, 2008

See these two "articles" on my website for possible ideas:

Write Data From a Recordset into an EXCEL Worksheet using Automation
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#WriteRstFile

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ExpRange

transferspreadsheet or output action

Sue R

Ken Snell \(MVP\)