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

Can you pls give some code, how exactly you are trying and where the problem is coming...