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

Marvin,
I still use XL2K, so I can't test it, but from
http://msdn.microsoft.com/library/en...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

"Marvin" wrote in message
...
How can I detect if the speech feature is installed in Excel?

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.

"Marvin" wrote:

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

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.Version10 (or 11 ?).

NickHK

"Marvin" wrote in message
...
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.

"Marvin" wrote:

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