Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from Access
Every time I export a file to Excel, I need to change the font in the
exported Excel file from Ms Sans Serif to Arial, even though Arial is the default font in Excel. How/what can I change so that the exported file will use the Arial font? I also need to recreate the Header & Footer, although I've created a Sheet.xlt template for all new Excel files. Why doesn't the Excel file that's created when I export from Access use this template, and can I create a template that it will use? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from Access
Are you doing this in VBA or just exporting a table using menu commands?
One way to achieve what you want is to work from the other side of the street: Create your template file. When you get ready to import data, start a new workbook based on that template, then use Excel's Data | Import and browse to the .mdb file with the table in it, identify the table and pull it in. Comes in to my test setup in Ariel, and preserves headers on the sheet. If you're doing this in VBA code from within Access, just add code to format the cells in your Excel object's (assuming you have one) worksheet(s) and the header for them in the code. If you're creating an instance of Excel and a workbook over in Access code, then you should be able to create the workbook from the template file also - I do it all the time with some Access applications that provide reports via Excel for many uses. "jhrBanker" wrote: Every time I export a file to Excel, I need to change the font in the exported Excel file from Ms Sans Serif to Arial, even though Arial is the default font in Excel. How/what can I change so that the exported file will use the Arial font? I also need to recreate the Header & Footer, although I've created a Sheet.xlt template for all new Excel files. Why doesn't the Excel file that's created when I export from Access use this template, and can I create a template that it will use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to export a .xls table to Access .mdb without Acc | Excel Discussion (Misc queries) | |||
Export to Access from Excel | Excel Discussion (Misc queries) | |||
Export from Access | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Export from Access to Excel | Excel Discussion (Misc queries) |