Report Labels are not there when exported to Excel

[MemphisVBA]

I have a report that has a few sub-reports and a few labels that help tell the person reading it what they are looking at. When it is viewed as a normal report object inside of Access, it is perfect, however when I export it to Excel (which is the format I need it in) I loose a lot of formatting and especially the text labels.
How can I get some text labels to show up on my exported Excel reports? I understand that there are several shortcomings on the Access reports - like formatting, lines, etc. Especially when dealing with snapshot v. MS Word - but I don't remember having this much trouble going from Access to Excel before.

For the record, here is how I am exporting to Excel:

    Dim stDocName As String

    stDocName = "Rebate Exception Report"

    DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, "Recon Exception.xls", True

Thanks in advance for any help or suggestions!

 

[MemphisVBA]

After reading some more posts, instead of making a report as an Access object and exporting it, should I instead write code to create a new Excel object and then populate it with a query - then I could designate what each cell would contain?

If you think this is the way to go, can you point me in the right direction as to how to make Excel execute your SQL via Access VBA? (hope that made some sense...)