You're welcome.
>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?
--sb--