Font of exported excel file 2

[SeeJane]

Hi all,

I'm hoping someone knows how to resolve an aggravation that's been dogging me for a while.

Is there a way to set the font for an excel spreadsheet exported from Access? I have set the default font for both Access and Excel to Tahoma (10 pt), which works just fine for creating anything new in either application. However, whenever I export a table from Access to Excel, the font of the new workbook is always Microsoft's default (Ariel, I think). Aaaahhh!

Thanks so much,
CJ

 

[hennep]

maybe i'm wrong but I think the only option is to open the spreadsheet after creation and set the font.
but the good news is, you can do it in code:

' remember to create a reference to the
' "Microsoft Excel 8.0 Object Library"
'
Dim ea As Excel.Application
DoCmd.Hourglass True
Set ea = New Excel.Application
Workbooks.Open FileName:="C:\sheet.xls"
Cells.Select
ea.Selection.Font.Name = "Tahoma"
ea.Selection.Font.Size = 10
ea.ActiveWorkbook.Save
ea.ActiveWindow.Close
ea.Quit
Set ea = Nothing
DoCmd.Hourglass False

 

[SeeJane]

Thanks a ton. It works beautifully!