Exporting 'save formatted' spreadsheets in code

[az_jackalope]

If I export a query from the Access file menu to an Excel spreadsheet and
check the "save formatted" box, the resulting spreadsheet has gray labels,
one particular number field that has custom formatting in the Access table
retains that custom formatting in the spreadsheet.

I can manually format the spreadsheet that way too, but it's nicer if Access
has already done it for me, to keep it and save me the extra steps.

If I transferspreadsheet in code, it doesn't do that. Is there a way to
"save formatted" in the code?

And what the heck is the 'UseOA' argument??!

Thanks

 

[tina]

you might try using the OutputTo action, rather than TransferSpreadsheet; it
may give you the result you're looking for. take a look at the topic in
Help, it gives a pretty thorough explanation of how the action works.

hth

 

[az_jackalope]

That worked great - thanks a bunch! Now - do you know what the "UseOA" is
all about?

 

[tina]

no, i haven't a clue.

That worked great - thanks a bunch! Now - do you know what the "UseOA" is
all about?

TransferSpreadsheet;

 

[Douglas J. Steele]

According to
http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthactTransferSpreadsheet_HV05186520.asp
it's actually not used.