Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet

[John]

I very much like the formatted excel file you get when you select "Analyze It
with MS Office Excel. The formating you get using DoCmd.TransferSpreadsheet
kind of sucks! Does anyone know how to get the formating that the Tools,
Office Links, Analyze It with Microsoft Excel gives you but using a VBA
command?

 

[outrigger]

You could go to a macro and use action "OutputTo", make the macro, save it,
then do the "convert macro to VB" under the tools menu.