Speaking error?!?

[Charlotte E.]

When I run this simple line...

Application.Speech.Speak "Hello"


....as given by the 'Help' file, I get this error:

Error #1004, Application-defined or object-defined error!


Why?!?

 

[Nigel]

I tried it in xl2007, both sheet module and standard module everything
worked fine!

 

[Barb Reinhardt]

It works in 2003 as well. Do you have your speakers on? What references do
you have set for your project?

 

[Peter T]

Have you installed speech.
View the Text to Speech toolbar.

Regards,
Peter T

 

[Charlotte E.]

Do you have your speakers on?
Yeps...

What references do you have set for your project?

Are any special references needed?
And which?

Have you installed speech?.

I've installed the MS Office Sounds, if that's what you mean?
Or does a special "Speech" package exists?



CE

 

[Barb Reinhardt]

I'm not sure if you need any references and if you do, which one is needed,
but it worked when I tried it in a project that had the following references
selected:

Visual Basic for Applications
Microsoft Excel 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.

 

[Charlotte E.]

I have the same references, and also...

Microsoft Speech Object Library

....but it just doesn't work!


Strange thing is that when I show the "Text To Speech" toolbar, all the
buttons are 'ghosted', and no matter what I do, I just can't get any of them
to work???

It is as if Excel simply won't recognize the speech abilities?!?

And yesterday, I even tried to do a repair of my Excel-installation, but
still no luck!

Any help would be greatly apreciated???


CE