>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
Basically, you can do a lot with Automation - see my introductory article at
http://www.utmag.com/wconnect/wc.dll?9,7,10,1562For instance, you could open an Excel Workbook, create a Spreadsheet, give the command to import from a DBF file (created in VFP with COPY TO ... TYPE FOXPLUS), create another Spreadsheet, ...
Or, alternately, paste a range of cells, which you previously prepared in VFP.
After that, you could select individual columns, change the width or the numeric format, etc.
All this can be automated.
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)