>>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..

I tried that but it did not work. Some commands do not seem to work