Use Excel as DCOM object
 

Hi,
I am novice in DCOM.
We have a very fat VB6 desktop application. The application has a lot
of Excel calculations that are retrieved and fed to the database. Also,
we are using Excel as a reporting tool after all the calculations are
done. I would like to "outsource" the Excel calculations to an
application server, because our clients seem to have obsolete PCs.
So, I create the Excel object on the remote server and the calculations
seem to be going well. However, I want to make the Excel object (or a
copy of the Excel object) visible on the client machine at the end so
that we can use its report. Is that possible?

Thanks,
Nik