Format Excel in Access

[Ack]

I want to use VB to export a report using OutputTo command to excel and then format the spreadsheet using OLE in access. I currently use a macro in Excel, but I would like to skip that step. I'm not having any luck getting it to work. Anybody got any ideas or examples??

 

[SKP626]

I've exported data from access to excel both by using OutputTo and also by using a Query from Excel. The data comes in as one long record, but I've created an extra sheet in the excel workbook to just house this data. My other "formatted" sheets then reference the data worksheet directly.

Good Luck,
Susan