>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).
Edward Pikman
Independent Consultant