Text to Speech in Excel 2004 for Mac

[mtilley]

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

 

[CyberTaz]

Hi Mark -

The bad news - You can't find it because it isn't there Mac XL doesn't
have the Text to Speech feature.

The _good_ news - that's because OS X, itself, provides the functionality.

Launch Mac Help, search on Text to Speech & follow the topic "Hearing your
computer speak selected text" & the associated links. You can assign a
keystroke so you can probably trigger it with an AppleScript.

BTW - I notice you're way behind the times with your Office updates -
current build is 11.3.5

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[gimme_this_gimme_that]

Yo pud "hello world" in da A1 of Sheet1 cell funky and be tryn dis ...
It'd be smellin


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

 

[Mark Tilley]

Thanks, Gimme

That worked perfectly!

Next time you're in Adelaide, I owe you a coffee!

Mark Tilley