Method speak of object speech failed

**ricklou** · 04-05-2019, 03:22 PM

Need some help -trying to run a simple speech macro and Im getting the following error.

Sub Speak()
Application.ScreenUpdating = False
Sheets("Test").Activate
Dim Lastrow As Long
Dim R1 As Range, R2 As Range, R3 As Range

With Sheet4      ' Change Sheet No. to suit
    For i = 8 To 8
        If .Range("J" & i).Value = .Range("K" & i).Value Or _
           .Range("J" & i).Value = .Range("L" & i).Value Or _
           .Range("K" & i).Value = .Range("L" & i).Value Then
    Application.Speech.Speak "You are not allowed to do that"
 
End If
    Next i
End With
Sheets("Test").Activate
Application.ScreenUpdating = True


End Sub

Rep for any help to solve above

**Richard Buttrey** · 04-05-2019, 03:38 PM

Try starting with

Dim s As Object
Set s = CreateObject("SAPI.SpVoice")

Then in the With block

s.Speak "You are not allowed to do that"

**ricklou** · 04-05-2019, 03:55 PM

Originally Posted by Richard Buttrey

Try starting with

Dim s As Object
Set s = CreateObject("SAPI.SpVoice")

Then in the With block

s.Speak "You are not allowed to do that"

Hi Richard
Thanks for suggestion

If i may ask you a question it runs fine on my one pc but other pc Im getting this error -any reason that might cause that as I find this very weird

p.S Your method did work -Thanks +++Rep

**Richard Buttrey** · 04-06-2019, 05:34 AM

What's the other PC and is it running the same Windows OS and Excel version?

Method speak of object speech failed

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Method speak of object speech failed

Re: Method speak of object speech failed

Re: Method speak of object speech failed

Re: Method speak of object speech failed

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Method range of object failed - Please help

[SOLVED] speech speak with message box and a reminder every 2 minutes

Speak - Speech - Speak numbers individually

vba code for activating Speech.Speak 25 pictures on page when 1 is selected speech follows

[SOLVED] How to make XL.Speech.Speak talk in a male voice

[SOLVED] Method range of object failed

Speech Object and Speak Method

Bookmarks

Bookmarks

Posting Permissions