Dennis,
It sounds as if you need to be doing something with the Excel OLE Automation server. Unfortunately, working in a Lotus shop as I do, my experience with that is, admittedly, limited.
Perhaps someone else can help here.
George
Ubi caritas et amor, deus ibi est