Don't want Excel Headings

[Greg]

I am using an OutputTo command within a macro to export a query to an excel spreadsheet. Unfortunately, the field description is making its way to the spreadsheet as a column heading. I only want to data, not a heading
Is there a way to prevent this? Maybe I'm using the wrong macro command
Thanks in advance. -Greg

 

[Ken Snell]

No ...that is the way it works (as does TransferSpreadsheet action). One way
to avoid it would be to use Automation to open EXCEL via VA code, open a
recordest based on your table or query, and have the code write the data,
cell by cell, to the spreadsheet.

--
- - - - - - - - - - - - - - - - -
Ken Snell
<MS ACCESS MVP>

I am using an OutputTo command within a macro to export a query to an

excel spreadsheet. Unfortunately, the field description is making its way to
the spreadsheet as a column heading. I only want to data, not a heading.

 

[Greg]

Ken,
Thanks for the reply.
I don't have much experience with VBA. I wonder if it wouldn't be easier to use the original macro to copy to the spreadsheet, then have the header row removed. I'd still have to open the spreadsheet but it seems the remaining steps would be simple.
As ugly as it sounds, does this seem reasonable?
-Greg

 

[Ken Snell]

Unreasonableness is in the eye of the person who will need to do this. If it
works for you, then it's reasonable!

--

Ken Snell
<MS ACCESS MVP>

Ken,
Thanks for the reply.
I don't have much experience with VBA. I wonder if it wouldn't be easier

to use the original macro to copy to the spreadsheet, then have the header
row removed. I'd still have to open the spreadsheet but it seems the
remaining steps would be simple.