Exporting format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shirley - 31 Jan 2004 17:33 GMT

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

Reply to this Message

John Nurick - 31 Jan 2004 18:27 GMT

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

>If I export a form to an Excel, the format in the form --
>font, cloor, bold--will be maintained in the Excel file.
[quoted text clipped - 9 lines]
>
>Shirley

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message