Text to Speech
 

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

Text to Speech
 

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

Text to Speech
 

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

Text to Speech
 

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

Text to Speech
 

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

Text to Speech
 

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

Text to Speech
 

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


There are two schools of thought.

One way is to buy a book or sign up for a course.

The other way is the throw yourself into the whole thing blindly,
stumble about for a while, learning as you go, ask a lot of questions
in this forum beginning with "Sorry, but I'm a noob ...", write some
bad code which works somehow, refine it, ask some more questions, get
your head around the arcane and verbose structures that VBA contains,
and finally, emerge like a badly beaten but victorious battle-hardened
VBA Hero.

Me? I couldn't afford a book, so I took the latter course. ;-) (Not
yet a hero though)

Greg

Text to Speech
 

http://msdn.microsoft.com/office/und...d/default.aspx

http://www.mvps.org/dmcritchie/excel/getstarted.htm

http://www.mvps.org/dmcritchie/excel....htm#tutorials
vba tutorial links are listed after the general excel tutorial links

--
Regards,
Tom Ogilvy



"James A" wrote:

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