exporting reports to excel worksheets

[harshal_mankodi]

i want to export the datarepport to excel worksheet.iam a begiiner so plz givethe code also and the libraries to include plz

[Arun Mittal]

Include the microsoft excel liberary in the references. For help file(on excel for vba) look into folder "microsoft office/office" if u have office 95/97 installed otherwise for office 2000 u will find the help file in folder "microsoft office/office/1033".

[harshal_mankodi]

hi plz give me the exactr code.thanking u again