Exporting to Excel: formatting lost??

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi there,

I need to export a table from Access as an Excel sheet, and I want to do
this programmatically. I therefore use the 'TransferSpreadSheet' method.
But the formatting (fonts, size, etc) of the table is lost in that case!

On the other hand if I select the table in the database window and then
click on the Excel icon in the toolbar to export it, the data is
displayed correctly in Excel. But I don't want to give my users access
to the database window!

So how can I combine the 2 methods to get the results that I want??

Any help is greatly appreciated!

Jerome
 
Check out the "OutputTo" method of DoCmd. It tends to mimic the UI behaviour
that you prefer (i.e., Office Links or Save formatted). Be sure to also read
the related Action topic for greater detail.

HTH,
 
Yes, I know. But you can format the data in the table in Access and then
export it like that into Excel. And that's what I want to replicate
programmatically ...
 
Back
Top