How to export data from QTP to Excel sheet?

[mansis]

Hi,

I want to export data from QTP to excel sheet and then I need to write the data in Excel sheet.

Following is the script which I prepared.. But it is giving error. Please let me know that what is wrong in below script.

------------------

Code:

display= Browser("Food product").Page("Entry").Frame("Frame").Link("Username").GetROProperty("innertext")

msgbox display

DataTable.Export("D:\Emp")

'To post the value of var in excel sheet

DataTable.Value("Detail",Sheet) = display

----------
Thanks.