Results 1 to 2 of 2

Speech Object and Speak Method

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Apex, NC, USA
    MS-Off Ver
    Office 365
    Posts
    64

    Speech Object and Speak Method

    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.
    Last edited by DanBlum; 07-13-2011 at 08:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1