export to exce spread sheet

S

SageOne

can i set and save certain format properties for my excel spreadsheet to
display when exporting a spread sheet from access? for example, if i generate
a spread sheet in access and always want to export a spreadsheet into excel
with all data "center aligned" in the excel columns.
 
T

Tom van Stiphout

On Mon, 25 Aug 2008 19:26:02 -0700, SageOne

This worked for me:
Export data using DoCmd.TransferSpreadsheet.
Open the file just created, select the worksheet just created.
Format a column as centered.
Delete all data but leave the worksheet in place
Re-run the export
Observe the column is still centered.

-Tom.
Microsoft Access MVP
 
Top