Hello,

I use message boxes to display the end of a macro/code. I would like for a
voice to also speak the message when the code is complete. Is it possible to
add voice responses. What would the code look like for a voice response.

Thank You,

Application.Speech.Speak "Hello"


"tjh" wrote:

Hello,

I use message boxes to display the end of a macro/code. I would like for a
voice to also speak the message when the code is complete. Is it possible to
add voice responses. What would the code look like for a voice response.

Thank You,

there is a library you can add on from the VBE called Microsoft Direct
Speech Synthesis

tjh wrote:
Hello,

I use message boxes to display the end of a macro/code. I would like for a
voice to also speak the message when the code is complete. Is it possible to
add voice responses. What would the code look like for a voice response.

Thank You,

Application.Speech.Speak "I am done"

HTH

Die_Another_Day

wrote:
there is a library you can add on from the VBE called Microsoft Direct
Speech Synthesis

tjh wrote:
Hello,

I use message boxes to display the end of a macro/code. I would like for a
voice to also speak the message when the code is complete. Is it possible to
add voice responses. What would the code look like for a voice response.

Thank You,

When I run this code I get a the error: "run-time error 1004" which is an
"Application-defined or object-defined error" .

I have added the Reference you suggested to the Microsoft Direct Speech
Synthesis.

Any suggestions on how to correct this.

Thank You,




"Die_Another_Day" wrote:

Application.Speech.Speak "I am done"

HTH

Die_Another_Day

wrote:
there is a library you can add on from the VBE called Microsoft Direct
Speech Synthesis

tjh wrote:
Hello,

I use message boxes to display the end of a macro/code. I would like for a
voice to also speak the message when the code is complete. Is it possible to
add voice responses. What would the code look like for a voice response.

Thank You,

Application.Speech is only supported on XL2002 (or 2003 ??) and higher.
How are you using the Microsoft Direct Speech Synthesis.

NickHK

"tjh" wrote in message
...
When I run this code I get a the error: "run-time error 1004" which is an
"Application-defined or object-defined error" .

I have added the Reference you suggested to the Microsoft Direct Speech
Synthesis.

Any suggestions on how to correct this.

Thank You,




"Die_Another_Day" wrote:

Application.Speech.Speak "I am done"

HTH

Die_Another_Day

wrote:
there is a library you can add on from the VBE called Microsoft Direct
Speech Synthesis

tjh wrote:
Hello,

I use message boxes to display the end of a macro/code. I would like
for a
voice to also speak the message when the code is complete. Is it
possible to
add voice responses. What would the code look like for a voice
response.

Thank You,

I am using XL2003. I was testing out the message below submitted earlier in a
subprocedure, but I still get the run-time error. Any suggestions.

This is the test procedure I used:

Sub speaktester()

Application.Speech.Speak ("Hello")

End Sub







"NickHK" wrote:

Application.Speech is only supported on XL2002 (or 2003 ??) and higher.
How are you using the Microsoft Direct Speech Synthesis.

NickHK

"tjh" wrote in message
...
When I run this code I get a the error: "run-time error 1004" which is an
"Application-defined or object-defined error" .

I have added the Reference you suggested to the Microsoft Direct Speech
Synthesis.

Any suggestions on how to correct this.

Thank You,




"Die_Another_Day" wrote:

Application.Speech.Speak "I am done"

HTH

Die_Another_Day

wrote:
there is a library you can add on from the VBE called Microsoft Direct
Speech Synthesis

tjh wrote:
Hello,

I use message boxes to display the end of a macro/code. I would like
for a
voice to also speak the message when the code is complete. Is it
possible to
add voice responses. What would the code look like for a voice
response.

Thank You,