I have a lot of large, long running macros and needed something to notify me when it was done. Here's a nice feature I came across while looking for something to play a sound when a macro is finished or has a problem and this is even cooler although it'll eventually probably get on my nerves. Application.Speech.Speak ("Type what ever you want the macro to say here.")The object can be a string, variable or concatenated strings, numbers, etc. It works really well to verbalize performance status, error counts and completion messages. Now, if I can just get it to quit saying "I'm afraid I can't do that, Dave..."

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Speaking Macros

Thread starter Eldrod
Start date Jun 9, 2010
Tags

excel vba speech

Eldrod

Board Regular

Jun 9, 2010

I have a lot of large, long running macros and needed something to notify me when it was done. Here's a nice feature I came across while looking for something to play a sound when a macro is finished or has a problem and this is even cooler although it'll eventually probably get on my nerves.

Code:

Application.Speech.Speak ("Type what ever you want the macro to say here.")

The object can be a string, variable or concatenated strings, numbers, etc. It works really well to verbalize performance status, error counts and completion messages.

Now, if I can just get it to quit saying "I'm afraid I can't do that, Dave..."