>>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.
>
>OLE Automation create (by CREATEOBJECT) Excel Application Object which allows you to use all Excel PEM (I believe AutoFormat and Print are performed by some methods, just check Excel VBA Help).

...or my favorite method for finding the code to set properties via OLE; In excel, set the properties opposite of what you want them and then record a macro of you changing them. Observing the code in the macro is usually enough to give you the function names and parameters list so you can set them programmatically.