Works great. Thanks again Sergey.
>Maybe it's not a shortest way but it works
>
>oWorkbook.Sheets.Add(,oWorkbook.Sheets(oWorkbook.Sheets.Count))
>
>>
>>It has been a long time since I have tried to automate excel. I need to add a new worksheet to the end of the list. I can't seem to make the parameters work with the add() method.
>>
>>o.ActiveWorkbook.Sheets.Add()
>>
>>I seem to remember that you can't pass named parameters with vfp so how do I make this work?