Jul 14 2021 05:18 PM
Hello
I am noticing that when there are negative numbers, the text to speech ignores the negative and only gives me the number. Is there some setting for this that I need to adjust?
Jul 15 2021 02:20 PM
SolutionJul 15 2021 02:26 PM
@German_Chris Thank you so much for your reply. Yes, I always have them in brackets. But good to know for the T to S, I will have to change it. It works now. Thank you again!
Jul 16 2021 10:03 AM
Jan 03 2022 10:40 AM
@Sudhaji check the string you're sending to the speech module. I had the same problem with the minus sign until I realized that I hadn't isolated the number value from the text that comes before it, as shown in this example:
Application.Speech.Speak ("The number is" & intVariable)
Adding a space allowed the speech module to recognize the sign:
Application.Speech.Speak ("The number is " & intVariable)
A quick test showed that VBA just works with the base value of the cell and can't see the cell formatting. Specifically, writing the cell value to the debug window with debug.print() gives a standard negative number regardless of cell format. The vocal output was also just the base value.
Jul 15 2021 02:20 PM
Solution