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.