Question about Speech

[Albert]

Hello!
I have both Excel 2003 and Excel 2007 installed in my computer.
When I use application.speech.speak("Hello") in Excel 2007 it works great.
However, in Excel 2003 I get an error 1004 with the same procedure.
Is there a way to install the speech in Excel 2003?
I thank you in advance,
Albert C

 

[scattered]

Hello!
I have both Excel 2003 and Excel 2007 installed in my computer.
When I use application.speech.speak("Hello") in Excel 2007 it works great..
However, in Excel 2003 I get an error 1004 with the same procedure.
Is there a way to install the speech in Excel 2003?
I thank you in advance,
Albert C

Seems to be a bug in Excel 2003 since the online help for it indicates
that it *should* work. In any event, try:

Sub Test()
Dim MyVoice As Object
Set MyVoice = CreateObject("Sapi.SpVoice")
MyVoice.Speak "Hello"
End Sub

and see if that does it for you

-scattered

 

[Albert]

Thank you sirrrrr....
Great Success!!!!

Seems to be a bug in Excel 2003 since the online help for it indicates
that it *should* work. In any event, try:

Sub Test()
Dim MyVoice As Object
Set MyVoice = CreateObject("Sapi.SpVoice")
MyVoice.Speak "Hello"
End Sub

and see if that does it for you

-scattered

 

[Marvin]

I have a long narrative using this method and cannot find a way to esc out
once it starts speaking. Any help would be greatly appreciated.