>May i know where can i get more information about sending report to excel? where can i get the information like the excel properties and methods?

You can get a good idea of excel properties by Opening an excel spreadsheet, click TOOLS, MACROS, VISUAL BASIC EDITOR. On the left side of the screen there will be a list of properties for worksheets, workbooks, etc... I checked this in Excel97.