I am playing with the Speech object and speak method and can't get it to work. This seems pretty basic. I'm using Excel 2003 on Vista.
My test code is:
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 7/12/2011 by Dan Blum
':confused:
'
Worksheets("danscsv").Activate ' Added as a guess that I needed to activate ' ' worksheet
Range("A1:C1").Select ' recorded
Selection.Copy 'recorded
Range("A2").Select 'recorded
ActiveSheet.Paste 'recorded
Beep 'Manually added seeing if this works....it did
Application.Speech.Speak ("Hello") 'gives error message described below
End Sub
When I run the macro, I get
Run-time error "1004"
Application-defined or object defined error.
What did I do wrong? Where should I have looked (what reference) to figure this out for myself.
Bookmarks