In a COM component I've written I create an Excel object then do things with it. This works OK on my development machine (both as un-compiled code and as a DLL in my local MTS package), but once I put it on the MTS server it fails
at the point of trying to create the Excel object (Set oXL = CreateObject("Excel.Application"
with a permisions denied error.
I've run FileMon.exe on the server to trap where the permissions denied error is originating, but this shows up nothing, so presumably the message text is VB doing one of its tricks.
I've tried doing a full Excel installation on the server (much to the annoyance of the support team... ho hum) but this makes no difference.
I'm still fairly new at Com so maybe I'm missing something simple here.
Any iedas?
Cheers
Sam Shiell
at the point of trying to create the Excel object (Set oXL = CreateObject("Excel.Application"
with a permisions denied error.I've run FileMon.exe on the server to trap where the permissions denied error is originating, but this shows up nothing, so presumably the message text is VB doing one of its tricks.
I've tried doing a full Excel installation on the server (much to the annoyance of the support team... ho hum) but this makes no difference.
I'm still fairly new at Com so maybe I'm missing something simple here.
Any iedas?
Cheers
Sam Shiell
