PDA

View Full Version : Text to Speech in Excel 2004 fro Mac



Mark T
8th June 2007, 06:18 PM
I would like my mac to speak the contents of a cell (the cell is a formula but which is a reference to a cell containing text) when I run a macro.

I can't seem to find a text to speech command. Is there any way I can do this, perhaps by expanding the macro?

I do notice that Word does have a text to speech command of sorts.

BTW, I'm using Excel v 11.1.1 and OS X 10.4.9

Thanks for any help

Mark T
9th June 2007, 06:58 PM
If anyone is interested, I found the answer on microsoft.public.mac.office.excel (many thanks to "gimme_this_gimme_that")

and the answer was…



Sub helloworld()
Dim b As Workbook
Dim s As Worksheet
Set b = ActiveWorkbook
Set s = b.Sheets("Sheet1")

Dim t As String
t = "tell application " & Chr(34) & "SpeakableItems" + Chr(34) &
Chr(10)
t = t & " say " & Chr(34) & s.Range("A1").Value & Chr(34) + Chr(10)
t = t & "end tell" & Chr(10)
MacScript (t)
End Sub


works perfectly!

Mark T