Error Handling for speech module?

SURFER349

Board Regular
Joined
Feb 22, 2017
Messages
50
So I've got this code to talk to the user while the macro runs, to prevent them from clicking all over the place and crashing the program.


Code:
Sub UseSpeech() 'speech while macro runs. 
Application.Speech.Speak "Hello  " & Application.UserName & ".  Please wait about 10 seconds while the macro runs in the background.", SpeakAsync:=True
End Sub

So it works great on most computers, but some people are getting this error.

Run-time error '-214720096 (8004503a)
Method 'Speak' of object 'Speech' failed

I don't want to ask all these old people to update their dll's and objects. Can someone help me with syntax for an error handling that will skip if there's an error here?
 
So I think the easiest solution would be help on how to use error handling. Any tips? Is speech error different than other errors? What about just general error handling?
 
Upvote 0

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
So you want to continue to use the babbling computer? And do what when an error occurs -- ignore it?
 
Upvote 0
So you want to continue to use the babbling computer? And do what when an error occurs -- ignore it?

yes. I don't see a good or clear path to implement a progress bar.

is it something as simple as
Code:
On Error Resume Next
 
Upvote 0

Forum statistics

Threads
1,224,827
Messages
6,181,197
Members
453,022
Latest member
RobertV1609

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top