Consulting

Results 1 to 9 of 9

Thread: Solved: About Application.Speak

  1. #1
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location

    Solved: About Application.Speak

    Hi everyone!
    It's me again.

    I wrote these codes as a joke next week. After i run the code Excel is speaking for all things that what i do in Excel. I can not stop this.
    Can you help me about stoping the speak method of Excel until i write an another code which is includes speak method?

    Thank you.

    [VBA]
    Sub LetsSpeakTheWhoIsTheBetter()

    Fenerbahce = 6
    Galatasaray = 0

    [A1] = "Fenerbahche is Better than All others"

    Do

    Range("A1").Speak

    Loop Until Galatasaray >= Fenerbahce

    'You can stop this by Ctrl & Pause Break: End
    End Sub
    [/VBA]
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    You've forgotten to increment the Galatasaray variable
    [VBA]
    Do
    Range("A1").Speak
    Galatasaray = Galatasaray + 1
    Loop Until Galatasaray >= Fenerbahce
    [/VBA]
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  3. #3
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location
    I think i couldn't tell the problem.

    I wrote the code as a joke.

    The code like a cercular reference of formulas, i know.

    I know do-loop but, my problem not about the code, still my Excel Appication is speaking. I break the code last week. Since i stop the code, while i working in Excel, Excel is speaking my every input to spreadsheet.

    For example, i am writing to A1 cell "Hi there" then Excel is speaking "Hi there" at the moment.

    But i closed that code last week...

    Can i tell it?

    Please help me.
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

  4. #4
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location


    I'll see what I can find.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  5. #5
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    1. Where did you add this code?
    2. Check if Narrator is turned on.
    Programs/Accessories/Accessibility/Narrator
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  6. #6
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location
    Quote Originally Posted by mdmackillop
    1. Where did you add this code?
    2. Check if Narrator is turned on.
    Programs/Accessories/Accessibility/Narrator
    I wrote at Module2 of a saved Spreadsheet.

    My Win. XP Pro is Turkish Edition.

    Translation: English - Turkish...

    Programs = Programlar : Ok.
    Accessories = Donatılar : Ok.
    Accessibility = Erişlebilirlik : Ok.
    Narrator = What ? I couldn't found it.
    You mean (Hizmet Programı Y?neticisi) Service Program Manager ?

    I can not find "Narrator"...
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

  7. #7
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Narrator is used to read what is typed. You may not have it enabled (Windows option)

    I'm not experiencing your problem with the code, thankfully. but I'll look further.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  8. #8
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location
    Quote Originally Posted by mdmackillop
    Narrator is used to read what is typed. You may not have it enabled (Windows option)

    I'm not experiencing your problem with the code, thankfully. but I'll look further.
    Narrotor should be in Turkish "Anlatıcı" or "Konuşmacı" or "Spiker" ect. But I can not found.

    Anyway,

    I want to thank you for all.

    Best regards.
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

  9. #9
    VBAX Tutor Erdin? E. Ka's Avatar
    Joined
    Sep 2006
    Location
    Bursa
    Posts
    264
    Location
    Hi everyone!

    Thank Allah! Finally I found the correct solution to silence Excel application.

    Here is the codes:

    [VBA]
    Sub ShutUpExcel()
    Application.Speech.SpeakCellOnEnter = False
    End Sub
    [/VBA]

    Thanks a lot for all hepls.
    Erdin? E. Kara?am | Loves from Bursa city in Republic of T?rkiye

Posting Permissions

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