Inserting a table heading into an MS Excel export of MS Access data

[tranchemontaigne]

I am successfully exporting data into MS Excel from MS Access using docmd.outputto syntax.

I want to add a table title to the exported data and am not sure the best way to do this. Can I use a DDE command to insert a new row 1 into the MS Excel spreadsheet?

If so then I could use a DDE POKE command to add a string to the value of cell A1 to create a table title.

Any thoughts on syntax or approach would be greatly appreciated. My experience with DDE POKE is very limited.

 

[PHV]

Why not OLE automation instead of DDE ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886