Initialize Event

Occurs when the Spreadsheet Component is loading, but before it is loaded completely.

Object   The name of the Spreadsheet object that you are trapping this event for.

Remarks

Use this event to initialize the settings for the spreadsheet.

Example

This example uses the Initialize event to set the spreadsheet data from a file on the user's computer.

Sub Spreadsheet1_Initialize()

   ' Load a CSV file into the spreadsheet.
   Spreadsheet1.CSVURL = "Data.csv"

End Sub