>>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.
>>
>
>You're on the right track. You do use SaveAs and pass the file format as the 2nd parameter. You probably want a CSV file - the constant for that is 6.
>
>oWorksheet.SaveAs("myfile.txt",6)
>
>Tamar
Thanks Tamar. Having that filetype parameter number is essential because the constant isn't built in to VFP.
Jeff Trockman, MCP