Detect which Version of OWC

[RDK45]

....Could someone please share with me some VBS code which can be used on the
client side to determine if OWC controls are installed on the PC and which
version?

Looking at the owcContol.Version (ie spreadsheet1.Version) returns the
correct version if the control specified for spreadsheet1 object exist, but
otherwise it does not even seem to trigger an ERR event if that control is
not present and the area for the object on the page has the red "x" in the
upper left corner.

Thanks....RDK

 

[Alvin Bruney [MVP]]

I have a code snippet or two to do just that on my website under Excel code
snippets
http://tinyurl.com/3he3b

 

[RDK45]

Alvin....Many thanks. After I posted my question I found a reference
(server-side, not client-side as I wished) which referenced the object as
'CreatObject("OWC.Chart")'. I used this in my client-side code and it found
my version 9 OWC charting control and provided me with the exact version
level.

Could this 'OWC.Chart' designation be a 'generic' object name for the
charting control on that particular machine. Would it thus return 10 or 11
on a different machine with Office XP or Office 2003?

Thanks again...Rob

I have a code snippet or two to do just that on my website under Excel code
snippets
http://tinyurl.com/3he3b

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

...Could someone please share with me some VBS code which can be used on the
client side to determine if OWC controls are installed on the PC and which
version?

Looking at the owcContol.Version (ie spreadsheet1.Version) returns the
correct version if the control specified for spreadsheet1 object exist, but
otherwise it does not even seem to trigger an ERR event if that control is
not present and the area for the object on the page has the red "x" in the
upper left corner.

Thanks....RDK

 

[Alvin Bruney [MVP]]

no, it should return only version 9 since version 10 and 11 are called
differently

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

Alvin....Many thanks. After I posted my question I found a reference
(server-side, not client-side as I wished) which referenced the object as
'CreatObject("OWC.Chart")'. I used this in my client-side code and it found
my version 9 OWC charting control and provided me with the exact version
level.

Could this 'OWC.Chart' designation be a 'generic' object name for the
charting control on that particular machine. Would it thus return 10 or 11
on a different machine with Office XP or Office 2003?

Thanks again...Rob

I have a code snippet or two to do just that on my website under Excel code
snippets
http://tinyurl.com/3he3b

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

...Could someone please share with me some VBS code which can be used

on
the

client side to determine if OWC controls are installed on the PC and which
version?

Looking at the owcContol.Version (ie spreadsheet1.Version) returns the
correct version if the control specified for spreadsheet1 object

exist,
but

otherwise it does not even seem to trigger an ERR event if that

control

is