Coann,
The best reference is the vbaxl8.hlp file in the Office folder. If you don't have the file you need to install it from the Office CD, it's an optional component. There is a link on my website to the MS Office Developers site. Also there is an article on my site with .h files for Word, Excel and Graph constants.
>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?