Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Speaking lists (2000 SP3)

    Hi,

    Does anyone know of a utility that will read out a list of numbers in Excel.

    Ideally, I would highlight a list of numbers, right-click and be given a choice to read out the highlighted list.

    I often have to check large lists of numbers & it would be a good, quick way to check them.

    Thanks,
    Jim MacLeod
    Shetland Isles

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Speaking lists (2000 SP3)

    See if Have a Talk with Excel works in Excel 2000.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Speaking lists (2000 SP3)

    Hi Hans,

    thanks for the suggestion but that option isn't in Excel 2000.

    Jim

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Speaking lists (2000 SP3)

    Thanks, you Macro was all I needed.

    BTW, the "Simple Text-To-Speech in Excel" link no longer has the .zip file.

    Thanks again,
    Jim

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Speaking lists (2000 SP3)

    Oops, I should have checked. I will edit my previous reply.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Speaking lists (2000 SP3)

    Edited by HansV because the add-in from the link near the end is no longer available.

    You should be able to write a macro for it:
    - Press Alt+F11 to activate the Visual Basic Editor.
    - Select Tools | References...
    - Tick the check box for "Microsoft Speech Object Library" and click OK.
    - Select Insert | Module.
    - Create the following macro:

    Sub SayIt()
    Dim Voice As New SpVoice
    Dim oCell As Range
    For Each oCell In Selection.Cells
    Voice.Speak oCell.Value
    Next oCell
    Set oCell = Nothing
    Set Voice = Nothing
    End Sub

    - You can assign this macro to a keyboard shortcut or toolbar button.
    - If you put the macro in one workbook, it will only be available there; if you put it in your Personal.xls, it will be available in all workbooks.
    - See <!post=Personal.xls Tutorial (All),118382>Personal.xls Tutorial (All)<!/post> for detailed info if necessary.

    Or you can use the code from Simple Text-To-Speech in Excel (Note: the page has a link to download an add-in, but that is no longer available, unfortunately)

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Speaking lists (2000 SP3)

    HI Hans

    I tried this out of curiostiy but I can't get it to stop speaking, and I can't turn it off.

    Any Ideas please

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Speaking lists (2000 SP3)

    What did you do? Select all cells in a worksheet? Try pressing Esc, this should pause the macro, with the option to end it.

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Speaking lists (2000 SP3)

    Hi Hans

    I am left with egg on my face here. I didn't use your macro, I used the method in the link Have talk with Excel.

    The reason for my embarrassment <img src=/S/blush.gif border=0 alt=blush width=15 height=15> is I had clicked on Speak on Enter and was trying to stop it with Stop Speaking Icon.

    My apoligies

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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