Try this :
xl = CREATEOBJECT("excel.application")
wb = xl.Workbooks.add
wb.Sheets.Add(,wb.sheets(wb.Sheets.Count),1)>Hi,
>
>I open a workseet in VFP 9, there are 1 sheet only,
>and I want to add a new sheet after the existing worksheet.
>
>I found the Excel Macro command is
> Sheets.Add After:=Sheets(Sheets.Count)
>
>how to convert it VFP 9 coding ?
>
>Please advise.
>Thanks.
>Derek Yim
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
