>I am using OLE Automation to feed a rather large 32 column crosstab
>result set to Excel. I am using Excel because of its print to fit and auto
>format capabilities.
>
>How can I automatically get the auto format and print to fit options of
>Excel set from VFP 5.0? I'd simply like to set up the spreadsheet
>print it and then release Excel and return control to VFP.

Check the ole examples provided with VFP...

Basically, what you can do is create a macro in Excel, edit and see how it is written in VB.(what functions etc. are used..)

Then through createobject create a excel object in VFP...

and write the related lines to print it..