>We are using OLEServer to create Excel Workbooks from VFP 6.0. We can create the workbook, add values, format it, and so on. But we cannot figure out how to use the SaveAs() function, because VFP does not support named arguments. Here is sample code:
>
>oWorkbook = createobject("Excel.Application")
>with oWookbook
> .WorkBooks.Add
> .Sheets("Sheet1").Name = "Count"
> .Cells(1,1).Value = 'Name'
> .Cells(1,2).Value = 'Product'
> .Cells(1,3).Value = 'Count'
> .SaveAs('C:\INV.XLS') && < OLE Error here
> .Close
>endwith=09
>release oWorkbook
>
>What are we doing wrong?
>
>Also, each time we run this program is starts up another Excel process. How do we terminate a process?
>
>Any help would be greatly appreciated.
>
>Michele Pace
>Areté Inc.
>arete@areteinc.com
To close Excel, use oExcel.Quit()
Erik Moore
Clientelligence