What is "a title for an Excel worksheet"? Do you mean, WorkSheet Name or page Header, or Column Title on the first row?
Anyway you need to use Excel Automation. For instance:
ObjExcel= CREATEOBJECT("Excel.Application")
with ObjExcel
.Workbooks.Open(fullpath(excelfile))
.Worksheets(1).Name="Hello"
.ActiveWorkbook.Save
.Workbooks.Close
endwith
ObjExcel.Quit
ObjExcel=.null.
RELEASE ObjExcel
>Hello all,
>
>I need to create a title for an Excel worksheet that is generated from a table.
>
>I already know how to create an Excel worksheet from a table using COPY TO.
>
>Thanks,
>
>Tunji.