Question about Speech
 

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

Question about Speech
 

On Aug 25, 3:04*pm, Albert wrote:
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

Question about Speech
 

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

"scattered" wrote:

On Aug 25, 3:04 pm, Albert wrote:
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

Question about Speech
 

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.

"Albert" wrote:

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

"scattered" wrote:

On Aug 25, 3:04 pm, Albert wrote:
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