If anyone could provide a solution to this problem below,
I have a similar issue and would appreciate some
assistance. If there is not a reasonably efficient way to
export to an excel template, is there a way to better
control the export format without writing a week's worth
of code? The limited formatting that one can do in the
datasheet/recordset view is insufficient.
I will rework all of my Excel macros, if required, but it
seems like there should be a better way.
It doesn't seem to be possible to do this using the standard export or
"analyze it" routines. Instead, you need to use Automation to create a
workbook from the Excel template and insert the data from the query. The
following links should help you get started.