I can't answer your question directly, but a trick I used when I was trying to figure out automation a couple years ago was to create a macro in Excel to do what I want and then port the code from VB to VFP.

Michelle

>I need to create a comma delimited text file from an Excel 97 spreadsheet using OLE Automation in VFP. I can't seem to find an example of how to do this.
>
>I know enough to instantiate Excel and open the workbook and navigate to the worksheet using the Excel object but how do I find the command to Save As comma delimited? Something like oWs.SaveAs("Myfile.txt",42) where 42 is the arbitrary number denoting the file type.
>
>Documentation is sparse. Thanks for your help!
>
>-JT