Copying field headers when exporting data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andrea.bruner@gmail.com - 15 Feb 2006 16:39 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 15 Feb 2006 18:51 GMT

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.

Signature

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

> 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
[quoted text clipped - 5 lines]
> Thanks,
> Andrea

Reply to this Message