Copying field headers when exporting data

[andrea.bruner]

I'm creating a VBA script in Access that will take data selected by a
basic query, place it in an Excel worksheet, and format the data. I
cannot figure out how to take the headers from the fields I select in
the query and place them at the top of the Excel sheet. I do not want
to hardcode the field names, as this script will be reused on various
datasets. Anyone have a suggstion?

Thanks,
Andrea

 

[Doug Robbins - Word MVP]

This group is for the use of Visual Basic in Word. Suggest that you post to
one of the Access or Excel newsgroups since you are trying to integrate
those two applications.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP