>I have a table with 2 fields, startdate and enddate. I use a copy to xl5 to get the data into excel format, but I want to change the Column headings form startdate to Report Start Date and enddate to Report End Date.
>
>Is there a way to do this besides a low level open and STRTRAN?
>
>Hope I was clear!
>
>Thanks!
Yes, after doing a COPY TO or EXPORT, open the file in Excel, and change the headers. This can be done automatically from VFP, with a process called Automation. See my article on Excel Automation, at
http://www.levelextreme.com/Magazine/September2002/Page45.asp.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)