Perry,

I have tried that, but it generates a syntax error.

Mark

>Mark,
>
>I don't have a chance to try this, but in the copy() part, the first paramter is the before parameter and the second one is the after. So, as I understand it, you would type
>
>".copy(,oleApp.Worksheets('sheet2'))" && note the ,
>
>to copy after sheet2.
>
>Give it a try.
>
>PF
>
>>What I have been able to do so far is to create a copy of the sheet before an existing sheet by using:
>>
>>oleApp = CREATEOBJECT("Excel.Application")
>>oleApp.Visible=.t.
>>oleApp.Workbooks.open(curdir()+"crosstab.xls")
>>oleApp.Worksheets('sheet1').copy(oleApp.Worksheets('sheet2'))
>>
>>This will work except that I need to have an extra page in the workbook and then delete it when done. I just can't find the proper syntax for passing the parameter to copy the page after an existing sheet. The help example I have found uses what VB calls Named Parameters which it can interpret and pass internally, but I can't find anything that defines the parameters for the Copy method.