How to Create an Excel Spreadsheet Using VB6

Creating Excel spreadsheets in Visual Basic 6 is beneficial for organizations that export these files through email or for presentations. Microsoft compilers like Visual Basic 6 can create, open, read and write to Excel spreadsheets. Microsoft provides a class that contains several methods and properties to use spreadsheets in customized applications.

Instructions

1. Instantiate three classes. The first one is for the Excel application. A workbook contains an Excel spreadsheet, so the code needs the instantiation of a workbook class and the spreadsheet class.
   Dim excapp As Excel.Application
   Dim excwb As Excel.Workbook
   Dim excss As Excel.Worksheet

2. Add a worksheet to the workbook to enter data. This also allows the programmer to set configurations and a layout for the Excel file.
   excss = excwb.Worksheets.add

3. Name the spreadsheet. Give the spreadsheet a friendly name with the following code:
   excss.Name = "My Excel Spreadsheet"

4. Create a header cell with column information. The following information creates a column of information with values entered into the cell:
   excss.Cells(1, 1).Value = "My Data"
   excss.Cells(2, 1).Value = "22.00"

5. Save the file to the hard drive.
   excss.SaveAs("C:\\myDir\myfile.xls")

References

• Codeguru.com: Creating Excel Spreadsheets and Charts from VB