Default font when exporting to spreadsheet format

H

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?
 
K

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.
 
G

Guest

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

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.
 
Top