Create Excel Workbook (BIFF8) without having Excel Installed

Category:
Office/VBA
Type:
Classes
Difficulty:
Intermediate
Author:
Alan Haigh

Version Compatibility: Visual Basic 6

More information:
This class will create a simple Excel Workbook(BIFF8 format) without having copy of Microsoft Excel installed. It has support for multiple sheets, Labels, Numbers, Dates, blank cells and has limited support for formula cells. includes support for print settings, lines, colors, patterns, text alignments, row heights, hidden rows, column widths, merged cells, number and date formatting, rotated and stacked text, password protection, etc See the supplied test project on how to use the class.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download vb excel.zip