DoCmd.OutputTo MS Access to Excel formatting workaround.

S

squirelle

Hello All

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?

Thanks!
squirelle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controlling MS Excel 97 from Access 97 (Using VBA) 0
Some of the sum totals are exporting to Excel 0
Export report to Excel, Error message "Compile Error: Argument not 0
DoCmd.outputto excel problem 5
Export Report with Graph to Excel error 2495 1
Access export to excel produces "unreadable data" 0
Export Access Table with Memo Field to Excel 2
docmd.outputto error 2

Top