Is there a third party library for Excel that would let me program in a
sentence so that when some condition is true the Excel spreadsheet starts to
speak in a loop?

For example, you might have a stock application that has the symbol MSFT and
a limit price of $25. When the stock trade above $25, you would program
the spreadsheet to say:

M S F T Above $25

The above would require me to:

1) Point the library to the "MSFT" string and to ask it to be spelled out
one letter at a time:

2) Add the word "Above" and ask it to be pronounced as a word.

3) Point to the cell with $25, and ask it to be pronounced as a dollar
amount.

Is there a way to do this?

--
W

On 21/08/2010 06:51, W wrote:
Is there a third party library for Excel that would let me program in a
sentence so that when some condition is true the Excel spreadsheet starts to
speak in a loop?

For example, you might have a stock application that has the symbol MSFT and
a limit price of $25. When the stock trade above $25, you would program
the spreadsheet to say:

M S F T Above $25

The above would require me to:

1) Point the library to the "MSFT" string and to ask it to be spelled out
one letter at a time:

2) Add the word "Above" and ask it to be pronounced as a word.

3) Point to the cell with $25, and ask it to be pronounced as a dollar
amount.

Is there a way to do this?


Have you tried using the built in speech routine?

Sub Spch()
Application.Speech.Speak "M S F T Above $25"
End Sub

On 21/08/2010 08:12, ManicMiner17 wrote:
On 21/08/2010 06:51, W wrote:
Is there a third party library for Excel that would let me program in a
sentence so that when some condition is true the Excel spreadsheet
starts to
speak in a loop?

For example, you might have a stock application that has the symbol
MSFT and
a limit price of $25. When the stock trade above $25, you would program
the spreadsheet to say:

M S F T Above $25

The above would require me to:

1) Point the library to the "MSFT" string and to ask it to be spelled out
one letter at a time:

2) Add the word "Above" and ask it to be pronounced as a word.

3) Point to the cell with $25, and ask it to be pronounced as a dollar
amount.

Is there a way to do this?

Supposing you have "M S F T" (with spaces as shown) in cell A4, "Above"
in cell B4 and "$25" in cell C4 then this will say the phrase:

Sub Spch2()
Dim i As Long

For i = 1 To 3
Application.Speech.Speak Cells(4, i)
Next i
End Sub