I hope that you found this tutorial helpful, I used many sites and books during the development of my solution, and this article including Dynamic Excel Reports with ASP and others which are no longer online unfortunately.
During the development of this tutorial, and afterwards, I've come across a selection of useful resource URLs that can assist in your developent of this type of application, some of the most useful are :
-
Microsoft Office 97 automation help file
A useful Windows helpfile covering details and examples of working with Office Automation. -
Microsoft Office 2000 automation help file
A useful Windows helpfile covering details and examples of working with Office Automation. -
The Excel Constant reference list.
Provides a list of all the Excel Constants and their underlying numerical values. -
The Microsoft Excel Language Reference for Excel 97 and Excel 2003 on MSDN.
Comprehensive reference of MS Excel (thanks to Jon Petter Austnes for pointing this out.) -
Getting Started with Microsoft Office VBA
Provides a introduction and samples on VBA, (A more detailed book version available from Amazon) -
Microsoft Support Article on the ActiveX component can't create object: 'createobject' error
Short article outlining the causes and some options for resolving this common issue when using the ActiveX approach. -
MSDN Sample Code
Code sample showing one possible way to handle the above error.