View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Albert Albert is offline
external usenet poster
 
Posts: 203
Default 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