Export to excell formating

[sjmojeck]

Is there any way to export a table to excel and have excel pre-formated (Font type, font size, column width, row height,etc...) Thanks

 

[RippleJD]

I would assume if you set a reference to the Microsoft Excel Object library inside your access app you should be able to set formatting for a given sheet. An easier method might be to set up a macro inside excel which would format the sheet (providing you are working with the same data each time.) I've never done either, though, so I'm sorry I can't be more specific.

Good Luck,

JD