I am in the process of developing a small Access database that pulls data
from linked datasources and pushes it through a report and exports into a MS
Excel 97 spreadsheet. Unfortunately when I use DoCmd.OutputTo none of the
orignal formatting applied to the report is exported with the data. I am
using the following VBA code to do this.
DoCmd.OutputTo acOutputReport, strRPT, acFormatXLS, ReportName & "_" &
strDate & ".xls"
I want to find a way to output this data across to MS Excel and then apply
formatting (Using Access VBA) to the spreadsheet so that it is aesthetically
pleasing. Is there a (non-dodgy) way that I can make this happen?