speech feature in excel

[Guest]

How can I detect if the speech feature is installed in Excel?

 

[NickHK]

Marvin,
I still use XL2K, so I can't test it, but from
http://msdn.microsoft.com/library/en-us/vbaxl11/html/xlobjSpeech_HV03080879.asp?frame=true
it seems that there is a Speech object. If you trap the error that will
occur, if speech is no possible when:

Dim Spch As Object
On Error Resume Next
Set Spch = Application.Speech
If Err.Number > 0 Then
MsgBox "Speech not available"
Exit Sub
End If

NickHK

 

[Guest]

Your approach does work. The system will return a 1004 if the feature is not
installed. I wrote code based on this general error number but would have
preferred to get at an actual detection test for this particular feature.
Thanks for your efforts.

 

[NickHK]

Marvin,
That is what you are doing. You are asking for a Speech object, Excel says
"Sorry I don't know what that is" and you react to it.
There is nothing wrong with dealing with errors; they provide information as
a positive result would.

I don't know if Speech is an optional installation, but you could just check
the if Application.Version>10 (or 11 ?).

NickHK