I'm using
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml,....

to create an xml worksheet where alpha column are left-justified and
numeric columns are right justified
if I want some columns to be centred, can I do this with
'transferSpreadsheet' or do I need to open the worksheet with excel
and run a couple of excel commands to select a column and center the
text

As far as I know, you cannot introduce formatting using TransferSpreadsheet.
You'd have to use Automation.

"Roger" wrote in message
news:b5b1761a-b9d9-4b5b-92f4-3fc2ed17e4cb (AT) r28g2000yqj (DOT) googlegroups.com...

I'm using
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml,....

to create an xml worksheet where alpha column are left-justified and
numeric columns are right justified
if I want some columns to be centred, can I do this with
'transferSpreadsheet' or do I need to open the worksheet with excel
and run a couple of excel commands to select a column and center the
text