Default font when exporting to spreadsheet format

[Heather]

When I export a table from Access to Excel format, the
default font of this file is MS Sans Serif font size 10.
Is there a way to change that value so the default font of
the exported file is Arial font size 8?

 

[Ken Snell [MVP]]

Change the font that the table is using to the desired font, and then export
the table. Export with "Save Formatting" option.

 

[Guest]

Thanks Ken,
Can this also be done via VBA code. Currently, I'm
calling the DoCmd.TransferSpreadsheet (acExport) function
to export the table.

 

[Ken Snell [MVP]]

The font change, to my knowledge, in a table cannot be done in code.
(Perhaps someone else knows of a way to do that.)

You would need to manually change the font setting in the table before you
run your code.