>Dear Sirs?madam
>
>I want to prinf a report in Excel Worksheet by tranferring my data from dbf file to the worksheet . All controls in my hand formating etc. So please advise if there is a programme in downloads or Give me Idea how to go about it .
>
>rahul
Rahul,
The fastest but not always possible way to transfer data to Excel is to 'copy to ...xls type xls' (I say not always possible for limitations on copy to excel copies 16384 rows - there are workarounds like saving as fox2x table, delimited etc or adding sheets to excel and pasting). Then you can open and do any formatting in Excel via automation.
Cetin