Initialize Event
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Occurs when the Spreadsheet Component is loading, but before it is loaded completely.
Private Sub Object_Initialize()
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