Hi Jeff,
You can have look at my Rep2Excel tool here in downloads. (Sept 2002)
Class objects is made of bunch of wrappers for common automation tasks.
So you can export your data any way you like using very simple calls like;
oXl.table_in_section(1,10,15,'YourTable','field1|field2|...')
(Strating at 1st sheet,10th row,15th column)
oXl.table_in_section(2,1,2,'YourTable','field1|field2|...')
(Strating at 2nd sheet,1st row,2nd column)
etc
It will be slow for bigger tables, since it uses OLE automation calls to write, but it can spare you of lot of excel macros converting / coding.
Rgds++
Sergio
>Hello,
>
>I am using VFP8 - is there a way to export to excel and not include the
>field names in the first record?
>
>Also, is there a way to export to multiple sheets in Excel?
>
>Thanks,
>
>Jeff