Jordan,
There's a link to the MS Office Developers Website over on my website. There's also a link to John Harvey's site which has some good automation articles. You can get the Excel97 constants from my site and a program that allows you to extract them into an .h file.
>i am currently adding a graphing section to a report of mine using the EXCEL API. however i can't find a reference on the net concerning this. is there a site that anyone knows that i can use?