SPEECH vba coding!!

[danoC]

I have been looking at methods of implementing text to speech in excel 2003. So far I have seen only this:

Sub talk()
Application.Speech.Speak "Hello! Blah Blah Blah!"
End Sub

Unfortunately my needs are slightly more complicated...
I'm running a program which uses a stored database of names at specific times whenever a button is pressed on a userform. I would like to incorporate array names (strings) along with a constant repeating portion. For example:

"Thank you! (variable name) is the next item."

Does anyone have some coding that may help me with this task?
Anything will help, I haven't found much from Googling!

 

[CT Witter]

Looks like you are on the correct track. You can reference the variable in the speech text.

For example,

Sub FillArrayMulti_Talk()
    Dim intI As Integer, intJ As Integer
    Dim sngMulti(1 To 5, 1 To 10) As Single
    Dim vartalk As String
    
    ' Fill array with values.
    For intI = 1 To 5
        For intJ = 1 To 10
            sngMulti(intI, intJ) = intI * intJ
            Debug.Print sngMulti(intI, intJ)
        Next intJ
    Next intI
Debug.Print sngMulti(1, 5)
Application.Speech.Speak "Thank you!" & sngMulti(1, 5) & "is the next item."
End Sub

HTH,
CT

 

[danoC]

Thanks CT. I'll give it a shot!