Exporting Reports with subreports to excel (1 Viewer)

[Snappy]

This code works fine and gets me what I need. But is there a way to have this code tell it to start on a certain line and not do headings. I want the template to have the headings. Thanks,

 

[GinaWhipp]

So sorry for delay, work just went crazy. You are using...

DoCmd.OutputTo acOutputReport, outReportData, acFormatXLS, xlFileName

I do not use that so I do not know of a way to specify where on the Template to drop it. Using code is the only I for that with which you can specific what row and\or column to start placing your data.

 

[Isaac]

This code works fine and gets me what I need. But is there a way to have this code tell it to start on a certain line and not do headings. I want the template to have the headings. Thanks,

Maybe just output the queries instead.

 

[GinaWhipp]

Outputting to queries won't work as you STILL need a way to tell it where on the Template to go.

 

[Gasman]

Have a look at this thread.

https://www.access-programmers.co.u...o-a-specific-table-and-range-in-excel.301362/

 

[Isaac]

Outputting to queries won't work as you STILL need a way to tell it where on the Template to go.

I guess I was thinking of avoid a 'report' header, but if they are wanting to avoid even column aliases I see what u mean