advertisement

Find Code  Advanced Search   

Free Newsletters:   
browse free vb code
Submit Code
ASP,  HTML, and XML
Database
Dates  and Math
Files  and Directories
Forms  and Controls
Lists,  Collections, and Arrays
Miscellaneous
Multimedia/Games
Office/VBA
Network/Internet
Registry
Screen/Graphics
String  Manipulation
System/API
Windows  2000/XP
VB.NET/ASP.NET



advertisement
Create Excel Workbook (BIFF8) without having Excel Installed

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

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.

This code has been viewed 103860 times.

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.

Source/006/vb Excel.zip

Sponsored Links