>Thanks for your help. The copy to and export to does not create the worksheet with date and numeric format. I thick I shall use you example to create a worksheet then fill it up with data. to set the font, you use "oSheet.Cells(1,1).Font.Size = 20" how can I set the format of a column eg date format, number format etc. ??? Your help will be appreciated.
Note that filling the spreadsheet cell by cell is much slower. You can often save time by copying lots of data first, and then applying formatting later.
This may be irrelevant for 1 or 2 pages, but quite relevant for 50-100 pages, for example.
The command to change the numeric format, in Excel, is "Format | Cells". Save a macro in Excel, give the format you want, and then take a look at the macro you created. This should give you the Excel commands, which should be relatively easy to translate to VFP.
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)