Exporting format

[Shirley]

If I export a form to an Excel, the format in the form --
font, cloor, bold--will be maintained in the Excel file.
If I export a table to an Excel, the format is gone,
although I have set the color and everything in table
design.

how can I maintain these format from table to Excel? Can
I set any format I want in exported Excel file in Access
code?

Thanks,

Shirley

 

[John Nurick]

Hi Shirley,

Data in an Access table doesn't have any formatting of its own, and when
you export the table all you are exporting is the data.

You can use Automation to control Excel from VBA code running in Access
to format cells in the worksheet (or do just about anything else). These
links should get you started:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476