Also, check out your VBA help in Excel. Just remember that the examples are VB, so you need to translate them to Pascal. For example, you need to pay attention to whether something is a function call or an array(like) dereference

In Delphi, all OLE/ActiveX automation objects are "variant".

Not too long ago I posted a lengthy example of Delphi code to build a rather complex spreadsheet.