Unusual Export Requirement

[Bill Sturdevant]

I need to export data to an Excel spreadsheet with column
headers. I am using "DoCmd.OutputTo" successfully and
getting the column headers.

BUT, I now have an unusual requirement. I need to export
records and headers as follows in order to product an
Excel spreadsheet to send to another company:

Row 1: Text data in certain cells
Row 2: Blank
Row 3: Column Headers
Row 4: Text data in certain cells
Row 5 and subsequent rows: the data being extracted.

What is the best way to accomplish this?

 

[Douglas J. Steele]

Try Automation.

See whether the sample at http://www.mvps.org/access/modules/mdl0006.htm at
"The Access Web" is enough to get you going.

 

[Bill Sturdevant]

Thanks for the suggestion -- I am willing to give it a
try, but I cannot figure out what library references I
need to execute the code. Can you help?

Bill

-----Original Message-----
Try Automation.

See whether the sample at

http://www.mvps.org/access/modules/mdl0006.htm at

 

[Douglas J. Steele]

In actual fact, the sample code doesn't require any library references to be
set: it's using Late Binding.

If you want to try Early Binding (which has the advantage that you get
Intellisense), the normal reference is Microsoft Excel x.0 Object Library,
where x is 8 for 97, 9 for 2000, 10 for 2002 and 11 for 2003.