Export to xls wrap problem

[Guest]

Hi
Thanks for reading this!
I have created a basic database, including macros etc (I'm only a beginner,
though!). The last part of one macro has to export a query (or a table) into
Excel format (Office 2000). When this file is opened in Excel, the cells are
set to 'wrap'. This means that if the cell is not wide enough to display all
its contents, it only displays the last bit. One entry might be 'EDINBURGH
HIGH SCHOOL' but only 'SCHOOL' is displayed. If I open the file and format
the cells not to wrap, it's fine. I was wondering if there is a way
(non-VBA, please!) to automatically export to Excel without having the cell
alignment to 'wrap'.
Cheers.

 

[John Nurick]

Hi Andy,

I'm not certain about this one, but if you're using OutputTo to export
to Excel, try using TransferSpreadsheet instead.