Don't want Excel Headings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>

Greg said:
I am using an OutputTo command within a macro to export a query to an
Click to expand...
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.
 
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
 
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>

Greg said:
Ken,
Thanks for the reply.
I don't have much experience with VBA. I wonder if it wouldn't be easier
Click to expand...
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.
 
Back
Top