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?!?

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

--

Regards,
Nigel




"Charlotte E." <@ wrote in message
...
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?!?

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

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



"Charlotte E." wrote:

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?!?

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


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?!?

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." wrote:


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


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?!?

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

Barb Reinhardt wrote:
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


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


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?!?

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

Regards,
Peter T


"Charlotte E." <@ wrote in message
...
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?!?