OWC9 and IIS6 CreateObject Failed

[Nicolas Tostin]

Hi,
I install OWC9 in spanish from my Office 2000 cd, and I tried to use again
my okd code to generate Spreadsheet that use to work on IIS4.

But when I do a
Set objSpreadsheet = Server.CreateObject("OWC.Spreadsheet")

It gives me an error : Server.CreateObject Failed.

I first thought it was an issue with server extension so I allow MSOWC.dll
in IIS6 but it didn't change anything.

I couldn't find any information on Microsoft web site or internet about this
issue.

Is anyone know if there is some incompatibility between IIS6 and OWC9 ?


Then, I decided to upgrade to OWC11 and now
Server.CreateObject("OWC11.Spreadsheet") works without trouble.
The only thing is that :
1. today we don't have a valid Office 2003 valid licence, so I think we
would buy one (well some to migrate our intranet workstations ) soon if
tests seems relevants.

2. OWC give me a very strange behaviour, it's unable to put a colour to fill
a cell :
objSpreadsheet.Range("A1").Interior.Color = "black" (or the same with
..ColorIndex = 1 ) doesn't seems to works and my cell stay white. Maybe it's
because I only had Excel 2000 with OWC11 but I don't think so, it should
work independantly....
(I will open a new thread for this issue, it was just to comment my OWC
migration).

3. I don't understand why I don't have to allowed a "web extension" on IIS6
to allow Server.CreateObject("OWC11.Spreadsheet"), I thought that the
lockdown state of IIS& prohibit anykind of application...



Thanks a lot

Nicolas

 

[Nicolas Tostin]

Ok seems ok to create OWC, that was just that the install doesn't register
MSOWC.dll fine....

I had to do : regsvr32 "C:\Program Files\Microsoft Office\Office\MSOWC.dll"
by myself