Message
 

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,

Message
 

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,

Message
 

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,

Message
 

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,

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,

Message
 

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,

Message
 

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,

Message
 

I would assume error is trying to you that should not use brackets around
the argument as you are not using the return value.

NickHK

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

Message
 

I tried it without the parenthesis (as below), and it gives the same error. I
am wondering if there is an option or installation that I need to do? I have
setup the Reference to Microsoft Text to Speech. Any suggestions?

Sub speaktester()

Application.Speech.Speak "Hello"

End Sub






"NickHK" wrote:

I would assume error is trying to you that should not use brackets around
the argument as you are not using the return value.

NickHK

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

Message
 

You do not need a reference to MS Text to Speech, as you are using the
engine built into Excel, hence the "Application" in your code.
If you are sure your version of Excel supports Speech, is it an optional
install ?

Also, it would help if you told us which error, we are not mind readers.

NickHK

"tjh" wrote in message
...
I tried it without the parenthesis (as below), and it gives the same
error. I
am wondering if there is an option or installation that I need to do? I
have
setup the Reference to Microsoft Text to Speech. Any suggestions?

Sub speaktester()

Application.Speech.Speak "Hello"

End Sub






"NickHK" wrote:

I would assume error is trying to you that should not use brackets
around
the argument as you are not using the return value.

NickHK

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

Message
 

Ok, Thanks. I got it working. I just needed to install it.

Is it possible to install it on a users computer using vba code, IF they do
not currently have it installed?

I would like to use it within some other VBA code.




"NickHK" wrote:

You do not need a reference to MS Text to Speech, as you are using the
engine built into Excel, hence the "Application" in your code.
If you are sure your version of Excel supports Speech, is it an optional
install ?

Also, it would help if you told us which error, we are not mind readers.

NickHK

"tjh" wrote in message
...
I tried it without the parenthesis (as below), and it gives the same
error. I
am wondering if there is an option or installation that I need to do? I
have
setup the Reference to Microsoft Text to Speech. Any suggestions?

Sub speaktester()

Application.Speech.Speak "Hello"

End Sub






"NickHK" wrote:

I would assume error is trying to you that should not use brackets
around
the argument as you are not using the return value.

NickHK

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

Message
 

Are you talking about Excel's .Speech or a separate component ?
If a separate component, you can copy & register files, depending on the
permissions the user has.

NickHK

"tjh" wrote in message
...
Ok, Thanks. I got it working. I just needed to install it.

Is it possible to install it on a users computer using vba code, IF they
do
not currently have it installed?

I would like to use it within some other VBA code.




"NickHK" wrote:

You do not need a reference to MS Text to Speech, as you are using the
engine built into Excel, hence the "Application" in your code.
If you are sure your version of Excel supports Speech, is it an optional
install ?

Also, it would help if you told us which error, we are not mind readers.

NickHK

"tjh" wrote in message
...
I tried it without the parenthesis (as below), and it gives the same
error. I
am wondering if there is an option or installation that I need to do?
I
have
setup the Reference to Microsoft Text to Speech. Any suggestions?

Sub speaktester()

Application.Speech.Speak "Hello"

End Sub






"NickHK" wrote:

I would assume error is trying to you that should not use brackets
around
the argument as you are not using the return value.

NickHK

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

Message
 

I am refering to Excel's Speech feature. I would like to install this feature
on the users computer, only if it is not currently installed.

Thanks,


"NickHK" wrote:

Are you talking about Excel's .Speech or a separate component ?
If a separate component, you can copy & register files, depending on the
permissions the user has.

NickHK

"tjh" wrote in message
...
Ok, Thanks. I got it working. I just needed to install it.

Is it possible to install it on a users computer using vba code, IF they
do
not currently have it installed?

I would like to use it within some other VBA code.




"NickHK" wrote:

You do not need a reference to MS Text to Speech, as you are using the
engine built into Excel, hence the "Application" in your code.
If you are sure your version of Excel supports Speech, is it an optional
install ?

Also, it would help if you told us which error, we are not mind readers.

NickHK

"tjh" wrote in message
...
I tried it without the parenthesis (as below), and it gives the same
error. I
am wondering if there is an option or installation that I need to do?
I
have
setup the Reference to Microsoft Text to Speech. Any suggestions?

Sub speaktester()

Application.Speech.Speak "Hello"

End Sub






"NickHK" wrote:

I would assume error is trying to you that should not use brackets
around
the argument as you are not using the return value.

NickHK

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