TEXT TO SPEECH CHANGES

Currently my text to speech config reads ONLY LETTERS if the letters are 
CAPITALs(IE when it come to the word ABLE, it speaks A B L E
how can I change the setting to make the system say "able"
Thanks

0
pcor (148)
1/4/2006 12:36:03 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
463 Views

Similar Articles

[PageSpeed] 2

Enter this small macro:

Sub Macro1()
    For n = 1 To 100
    Cells(n, 1).Speak
    Next n
End Sub

And it should "say" whatever text you enter in A1 thru A100
-- 
Gary's Student


"pcor" wrote:

> Currently my text to speech config reads ONLY LETTERS if the letters are 
> CAPITALs(IE when it come to the word ABLE, it speaks A B L E
> how can I change the setting to make the system say "able"
> Thanks
> 
0
GarysStudent (1572)
1/4/2006 1:28:03 AM
Thanks for the input but I guess I did not make myself very clear.
Using the "SPEAK ON ENTER" mode the voice does read back what is hilighted.
The   trouble is that if I have the word BASKET(all in caps) the voice says 
it sees a " B" then a "A" then a "S"...you get the drift. But if I spell the 
word "Basket"(not all caps), the voice does say "basket"
Is there a way to configute the text to voice function?
Thanks


"Gary''s Student" wrote:

> Enter this small macro:
> 
> Sub Macro1()
>     For n = 1 To 100
>     Cells(n, 1).Speak
>     Next n
> End Sub
> 
> And it should "say" whatever text you enter in A1 thru A100
> -- 
> Gary's Student
> 
> 
> "pcor" wrote:
> 
> > Currently my text to speech config reads ONLY LETTERS if the letters are 
> > CAPITALs(IE when it come to the word ABLE, it speaks A B L E
> > how can I change the setting to make the system say "able"
> > Thanks
> > 
0
pcor (148)
1/4/2006 10:15:02 PM
I don't have a guess, but I did try this in xl2003 and it spoke the words for
me--no matter how the text was capitalized (both in code or via the user
interface).

I looked through the help (and under tools|options) and didn't find a way to
change any of those settings.

I do use a USA dictionary--I don't know if that has any affect, though.

pcor wrote:
> 
> Thanks for the input but I guess I did not make myself very clear.
> Using the "SPEAK ON ENTER" mode the voice does read back what is hilighted.
> The   trouble is that if I have the word BASKET(all in caps) the voice says
> it sees a " B" then a "A" then a "S"...you get the drift. But if I spell the
> word "Basket"(not all caps), the voice does say "basket"
> Is there a way to configute the text to voice function?
> Thanks
> 
> "Gary''s Student" wrote:
> 
> > Enter this small macro:
> >
> > Sub Macro1()
> >     For n = 1 To 100
> >     Cells(n, 1).Speak
> >     Next n
> > End Sub
> >
> > And it should "say" whatever text you enter in A1 thru A100
> > --
> > Gary's Student
> >
> >
> > "pcor" wrote:
> >
> > > Currently my text to speech config reads ONLY LETTERS if the letters are
> > > CAPITALs(IE when it come to the word ABLE, it speaks A B L E
> > > how can I change the setting to make the system say "able"
> > > Thanks
> > >

-- 

Dave Peterson
0
petersod (12005)
1/5/2006 12:51:48 AM
Reply:

Similar Artilces:

How can I change the column order using VBA
I have written code that appends data to a table. Occasionally, I need to add more columns. To do this I am using a bubble sort to compare with my existing table weather i already have the column or not. Because of this, I make my new table in alphabetical order, but I would like to be able to reorder the columns into something other than alphabetical. Is there a column order property for tables? Any suggestions? Thank you. Balbina wrote: > I have written code that appends data to a table. Occasionally, I need to > add more columns. To do this I am using a bubble sort...

Personal workbook does not save when it changes
I am using XL 2002. I created a Personal workbook, put it in the XL startup folder, and hid it. But when I add a macro to it, I am not prompted to save it when I shut down XL. Why? Thanks, Billy When you start Excel and click on Windows - Unhide, does the Personal.xls file appear? Or is Unhide grayed out? I don't know how you created that file but you should let Excel create it and place it. To create the file, click on Tools - Macro - Record New Macro. When it asks where to place the macro, specify Personal.xls. I know it doesn't exist. Click OK. That's ...

Changing right side scrollbar bar row number box?
Hi, In excel when you click and hold the right hand scroll bar and move up and down the worksheet it displays the row number you are on. Is there any way to change that to pick up the value within column a instead? Many thanks, Rick I don't think so. In fact, when you upgrade to xl2k, those numbers disappear and the worksheet will scroll live--you'll see the worksheet change right before your eyes. (It works that way in xl2002. I _think_ xl2k is the first with this newer behavior.) "news.microsoft.com > > Hi, > > In excel when you click and hold the righ...

preventing a workbook being changed? (not as simple as it sounds!)
i am trying to prevent anyone being able to make changes to a workboo and something strange is happening. Ive put a password on the workbook by going to tools/options/securit and adding a "password to modify". now in theory this should prevent anyone ever being able to change m workbook without knowing that password. however ive had the workbook put onto the intranet, clicking the lin to it opens it in IE. if i make some changes in the workbook and the click the back button in IE, i get prompted to save the workbook due t changes. I can then click save and save the workbook to m...

Change Calender Start date
I want to add this to my code If [ckb7] = -1 Me!tbDateFrom = DateSerial(Year(Date), Month(Date) - 1, 7) Is this possible?.....Thanks for any Help............Bob Private Sub Form_Open(Cancel As Integer) Select Case Me.OpenArgs Case "OwnerStatement" Me.Caption = "Owner Statement" tbDateFrom.value = Format("01-" & Month(Now) & "-" & Year(Now), "dd-mmm-yyyy") tbDateTo.value = Format(Now, "dd-mmm-yyyy") ...

Pages keep changing position
I recently had Microsoft Office 2007 installed on my computer at work, and am having awful problems with Publisher 2007. I produce a multi-page newsletter which I originally created in Publisher 2000 and have imported into 2007. However, when I am in the middle of working on it, the pages seem to move around by themselves, so that page 1 may end up on page 7 and page 3 suddenly appear on the front cover! This makes me reluctant to save even the tiniest change in case other pages have moved spontaneously while I was working. Nothing in particular seems to trigger this movement. Has anyb...

Date changing to current date when doc reopened
When I draft a letter and save it and then reopen it later, the date always changes to the current date, even when I do not use the auto insert date. i erase the date and put it in manually but it still happens. -- Michele Michelle, sounds like you used teh insert date feature of Word. This inserts a current field, which will update every time opened. Try replacing the current date field with teh Create date field. HTH "Michele" wrote: > When I draft a letter and save it and then reopen it later, the date always > changes to the current date, even when I ...

Print preview in Publisher 2003 changes doc from landscape to portrait
A friend of mine is attempting to print out an 11x17 double-sided flyer in landscape mode on her XP Pro system. The 2-year-old template she uses prints correctly in landscape form, but if she changes the text and attempts to print or do a print preview, the orientation of the page immediately changes to portrait and will print out in that form. The fact that the original Publisher 2003 versions printed correctly but the newly edit version does not sounds like there is a page formatting problem occurring, but regrettably I'm not a publisher expert. Anyone have any insights what mi...

Changing the font style, fore colour and back colour of an individual cell in a VB6 listview
Hi All Again, another I've always left rather than sorting is the ability to style (bold, underline, italic), colour the text and colour the background of the text in a vb6 listview CELL. Are any of these permitations possible? Am I better using an MS Flexgrid and hidden textbox (for the edit bit)? Thank you. "Mojo" <please@dont.spam.com> wrote in message news:e%23LFCQ5RLHA.3792@TK2MSFTNGP06.phx.gbl... > Hi All > > Again, another I've always left rather than sorting is the ability to > style > (bold, underline, italic), colo...

edit word art text?
I am trying to edit word art text created in an earlier version of Publisher (1998) with Publisher 2007, but it is not supported. Any ideas how to do this? The recent version will allow changes to everything but the text. There is a WordArt compatibility utility. You use it by Insert, Object, Scroll down to WordArt 3.2. If you have the old WordArt on your screen and you have installed the utility, simply double-click the WordArt. Publisher 2003/2002 Add-in: WordArt Compatibility http://www.microsoft.com/downloads/details.aspx?FamilyId=897AA11B-A37D-4586-A1A7-54BBEA375AE2&displayla...

How do I fill down keeping one cell calculation from changing in .
If I have a calculation I want to fill down which has multiple calculations. How do I fill it down keeping one of the calculations constant. Meaning one of the calculations always uses the same cell for a calculation, it doesn't change as the cells go down. eg =SUM(A2*F13-J13) I wand to keep the A2 all the way down but want the others to change as it is filled down. Thanks, WC Look up About cell and range references in the HELP files. And try this: =SUM($A$2*F13-J13) -- HTH, RD ============================================== Please keep all...

Inserting Template truncates subject line text
When I insert a template into an email being written in CRM, it seems to truncate the original text in the subject line, and replace it with that of the template. This is not helpful, as it removes the subject line that should stay with the email, and even though i'm sure another identifier will be added to the email once sent, I have had to type out a manual subject line. An example of this is using templates to store a signature block. Since this didn't happen in 1.2, and I can;t see any way of turning it off, can anyone suggest a workaround, rather than copying & pasting...

text color
This is my second post on this problem. Using Pub. 2002 and HP6122 printer. Created a postal card and had a color problem. Created the card and changed some of the lines to a blue ink. Saved the doc. and decided to change the blue back to black. When I printed it out it wasn't sharp. In looking under a Magnifying glass I could see the blue color edge behind the black and it makes the type fuzzy. Contacted HP and they suggested I try the same procedure in other applications as Word, Notepad, Wordpad, Works, etc. The problem does not happen in other programs. HP says it is n...

Opening text file using Excel
When I choose Microsoft Excel Program to open a text file I get thi error "This file does not have a program associated with it fo performing this action. Create an association in the Folder option Control Panel" I used to open it few days back But I don't know what happened :-( al of a sudden it stopped working. I uninstalled and reinstalled O2k Pr with SP1 & SP3 still not working. Can someone help me out on this one. Thanks Addian -- Message posted from http://www.ExcelForum.com Hi If you right-click on the file, you should get an 'Open with . . ' option. Cli...

How to update Ft End Queries when changing Bk End Table Name?
I changed the name of a table on the Back End of the data base. I thought I could just repoint the queries in the Front End to the new table name by changing the query properties. Nope. Didn't work. How can I get the Front End to keep up with changes I make on the backend like changing a table name? thanks for any help. MyEmailList@gmail.com wrote: > I changed the name of a table on the Back End of the data base. > > I thought I could just repoint the queries in the Front End to the new > table name by changing the query properties. > > Nope. Didn't work. > &...

How do I change the color the cell becomes when doing a FIND
When I do a FIND or FIND / REPLACE, when Excel finds the value I am looking for, it highlights the cell, but the highlighted cell is in white, which is the standard sheet background. How can I change a setting so anytime I try to do a find, when the cell is found, it shows this cell in a totally different color say purple or red or yellow etc.. I find sometimes trying to identify which cell it has selected in a full screen of data can be tough. I jst want to be able to locate the selected cell easier. Thanks for your help Two known and common options to search ALL WB sheets....

Can someone PLEASE let me know how to change my desktop settings in Vista?
I have a Nikon D3000 which takes shots that are wider in ratio to their height than my monitor is. When I was running XP, it automatically displayed the wallpaper as widescreen, with bars at the top and bottom. My Vista set up doesn't do that automatically and I don't know how to make it happen. I'm no expert, but I've managed to do a little more in terms of fixing things than a lot of comp owners who aren't programmers have, but this baffles me, despite the fact there are probably teenagers in this city who use a machine 20 minutes a week who would know. And th...

Find Text in List Box
I've looked hi and lo for code to find text in a List Box using the Find input box in AC 2007. Finding text in the form works ok but finding it in a List Box doesn't seem to work. Can anyone point me to a web site or let me know what code I might need to accomplish this? Thanks, James Hi James, List and combo boxes are objects (controls) that have row and column properties. You need to find or write a routine that visits each column of each row in turn and tests for your search string. It seems to me this is a classic case for using VBA's OOP functionality. Design a class ...

VB6 - ADO
First I must to say Sorry, because my English is not the best. I have some values that I write into an Excel XP sheet from VB6 using ADODB connection. The problem is that in Excel XP sheet the numbers in the cells are formatted as text. (All the cells In Excel have a green error indicator in the upper left corner). To write the values in Excel sheet I use INSERT INTO � or AddNew and Update methods of the RecordSet. I would like to now how can I copy the values (or one column) of the MSFlexGrid to Clipboard. It is to Past to another application, like Excel Sheet or OriginPro 7. Thanks any He...

Changing Graph Title W/ Pivot
If I have 3 items I am showing on a pivot chart: cost of pears, cost of peaches, and cost of apples, can I make the title of the graph change if I just want to select a specific element . For instance when everything is select the title for the graph is "Cost of Fruit". What I want is if I only want to show apples I want the chart title to read "Cost of Apples". Any way to do this? Thanks in advance! Select a cell on the worksheet. Enter a formula that refers to the pivot page cell, e.g.: ="Cost of " & IF(B1="(All)","Fruit",B1) ...

Excel: Can't save changes to print number of copies setting
I inherited an Excel workbook that has the number of copies to print set to 10. I change it to 1, then save the file, but it always reverts back to ten. ...

excel case changes on a column of first names
Could somebody please tell me how to work the "proper" formula so that it will change a column of names from all caps to just first letter cap? I can get the formula to work for the first cell, but I can't get it to copy or paste, or paste special to the column below it. (I don't use excel very often and therefore have limited knowledge of these functions.) Thank you! jim_in_mich Jim, One easy way is to insert a new column next to the column that has the non-proper (upper or lower) case words or names. Presuming that you'd have the names such as JOHN DOE in A1 a...

Text Box in Forms
Why is it called a text box if I can't format it to accept text? I need to have a control/input on the form that will accept 1102A as an input to a query.Can you help me here? ThankYou "Gringarlow" <Gringarlow@discussions.microsoft.com> wrote > Why is it called a text box if I can't format it to > accept text? I need to have a control/input on the > form that will accept 1102A as an input to a > query.Can you help me here? There's nothing inherent about a Text Box that would prevent entering "1102A". Perhaps if you gave so...

how do you change the data order in a graph without modifying the.
how do you change the data order in a graph without modifying the table? I know it is possible if you change your table, but it is not very convenient. Thanks You can change the order of the series: double click a series, then rearrange the series in the Series Order tab. If you need to change the left-right order of categories along the X axis of a chart, you pretty much have to modify the table. If the table is for display, you could chart from a separate table, both tables linked to the same source data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutor...

my cursor won't change to a crosshair pointer in Publisher
When I click the text box button on the objects toolbar in MS Publisher '03, and move my mouse back to the area where I just deleted a text box, the pointer is supposed to change to the "draw a frame" or "crosshair" pointer, but nothing is happening. Can you tell me why? ...