Making Excel Speak in VBA
Can you use Excel’s text-to-speech functionality in VBA? You bet. Simply use this line of code: application.speech.speak and then specify your text in paranthesis or you can even use a variable. If your variable was called Announcement, your code would look like this:
application.speech.speak announcement
And to read text:
application.speech.speak (”This is the text!”)
Simple!