As an example, let's assume Spreadsheet needs to be started from another application (e.g. Write – but it could be any application that supports OLE automation) and a you want to create a new worksheet. Here's the code:
Set app = CreateObject("AbilitySpreadsheet.Application")
app.Visible
Set mywb = app.Workbooks.Add
Set myws = mywb.Worksheets(0)
myws.Cells(1, 1).Value = "A big hello to Spreadsheet"
The second line "app.Visible" causes the application to become visible to the user (otherwise the application would run in the background and not be visible). Next a new workbook is created and a reference to the first worksheet in it is saved as myws. Finally, some text is written into the cell A1.