tranchemontaigne
Technical User
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.
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.