OWC11 and OW10 side by side

[Jonathan Randle]

Hi,

We've currently got a page that displays an OWC11 pivot table and most
people are happy with this. A number of users, however, are not able to
download the latest version of office web components (2003) but do have
office XP installed. I have been asked to see if there is an efficient way
to check to see if they are unable to load the OWC11 component (I currently
just test for document.pivotTable.ActiveView = null) and if so, load the
OWC10 pivot table instead. Is there a way of achieving this? I have as yet
been unable to even display the OWC10 object.

Any advice on this would be most appreciated.

Cheers,
Jonathan

 

[Chris Magoun]

You could use some client-side script that tried to invoke the OWC version
11. If that script errors out, redirect them to a page with version 10.

As an example:
Function DetectOWCVersion()
On Error Resume Next

Dim owcV10
Dim owcV11

Set owcV11 = CreateObject("OWC11.PivotTable.11")

If owcV11 Is Nothing Then
Set owcV10 = CreateObject("OWC10.PivotTable.10")
If owcV10 Is Nothing Then
DetectOWCVersion = "NONE"
Else
DetectOWCVersion = "VERSION10"
'Alternately, you could redirect the browser to the owc10 page
End If
Else
DetectOWCVersion = "VERSION11"
End If

On Error GoTo 0
End Function

Not sure this helps, but I wish you luck,
Chris Magoun