How to create a macro to select a call and execute the text to play function.
--
James A

Sub ABC()
Range("B9").Select
Application.Speech.Speak ActiveCell.Text
End Sub


Assumes you have the speech capabilities configured.

--
Regards,
Tom Ogilvy


"James A" wrote in message
...
How to create a macro to select a call and execute the text to play
function.
--
James A

Thanks for responding - this looks like VBA that I don't know. Is there any
way to do it by just recording a macro?
--
James A


"Tom Ogilvy" wrote:

Sub ABC()
Range("B9").Select
Application.Speech.Speak ActiveCell.Text
End Sub


Assumes you have the speech capabilities configured.

--
Regards,
Tom Ogilvy


"James A" wrote in message
...
How to create a macro to select a call and execute the text to play
function.
--
James A

Turn on the macro recorder (Tools=Macro=Record a new Macro) and perform
the action manually. See if it records anything.

--
Regards,
Tom Ogilvy


"James A" wrote in message
...
Thanks for responding - this looks like VBA that I don't know. Is there
any
way to do it by just recording a macro?
--
James A


"Tom Ogilvy" wrote:

Sub ABC()
Range("B9").Select
Application.Speech.Speak ActiveCell.Text
End Sub


Assumes you have the speech capabilities configured.

--
Regards,
Tom Ogilvy


"James A" wrote in message
...
How to create a macro to select a call and execute the text to play
function.
--
James A

James,

Press ALT-F11 and copy the Code in the messages above (and prepare for
a whole new world of functionality to open up to you). Press F5 to run
it.


Greg

Fantastic - thank you so much. How would I go about learning VBA?
--
James A


"Greg Glynn" wrote:

James,

Press ALT-F11 and copy the Code in the messages above (and prepare for
a whole new world of functionality to open up to you). Press F5 to run
it.


Greg