I hope that you found this tutorial helpful, below are some of the sites that I used when I compiled this tutorial :
- Excel Generator Alberto Sartori (Planet Source Code)
- Creating Excel WorkSheets with ASP Wayne Berry (15 Seconds)
- Dynamic Excel Reports with ASP Steven Smith (ASP Alliance)
-
Using the ActiveX approach with .Net
An article covering the use of the ActiveX approach in a .Net application. -
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.) -
Microsoft Office 97/Visual Basic Programmer's Guide
Provides a wealth of information and samples on VBA, (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. -
Access to Excel Methods
An evaluation of the different methods that can be used to move data from Access to Excel.