+ Reply to Thread
Results 1 to 2 of 2

Speech Object and Speak Method

Hybrid 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.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,719

    Re: Speech Object and Speak Method

    From the microsoft site:
    Using the Speech object
    Use the Speech property of the Application object to return a Speech object.

    Once a Speech object is returned, you can use the Speak method of Speech object to play back the contents of a string. In the following example, Microsoft Excel plays back "Hello". This example assumes speech features have been installed on the host system.
    Sub UseSpeech()
    
        Application.Speech.Speak "Hello"
    
    End Sub()
    Note There is a speech feature in the setup tree that pertains to Dictation and Command & Control that does not have to be installed

    Have a look here also please
    http://support.microsoft.com/kb/277808
    Last edited by jolivanes; 07-12-2011 at 10:55 PM. Reason: Add hyperlink to support.microsoft

+ Reply to Thread

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