Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a title for a workshseet that is created from a t
Message
 
To
05/09/2003 08:53:14
Olatunji Beckley
O. A. Beckley Ventures
Nigeria
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00826363
Message ID:
00826369
Views:
21
This message has been marked as a message which has helped to the initial question of the thread.
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform