Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

tranchemontaigne

Technical User
Apr 26, 2004
44
US
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top