you can do just that with an activex automation server and a com-handle.
theres an example in %dlc%\src\samples\activex\excelgraphs\oleauto.p
take a look at the com objects, activex automation and controls support chapters in the programming interface doc.
for references on excel objects, methods, constants etc.
record a macro and open the macro to see how its done. hth