Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet

  • Thread starter Thread starter John
  • Start date Start date
J

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?
 
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.
 
Back
Top