Query Formatting & Exporing to Excel

[purceld2]

I have noticed that when I export a Query to Excel manually I have the option the Save formatting and the excel formatting resembles the formatting in Access. When the DoCmd.Transferspreadsheet method is used to export the query all formatting is lost.

How can I get the method to export with formatting?

How much formatting can be done in Access, can text be centred, text wrap etc or is it very limited and has to be done in Excel?

 

[pbaldy]

You don't have much control with TransferSpreadsheet, but you can do pretty much anything with automation. You essential open and control Excel from Access. Searching on that should turn up some code, but this may get you started:

http://support.microsoft.com/kb/246335