 Speech ComputingWhere Speech Meets Computing |
|
|
Registering and logging in removes this ad. User loginRegistering and logging in removes this ad.
Registering and logging in removes this ad. |
Speech Recognition in Excel
Submitted by xin on Fri, 07/21/2006 - 17:20.
Hi, I would like to know how to use speech recognition to add numbers into specified cells horizontally using macros.the numbers are said by the user. For example: the user says 5,10,15,20 and it will fill it into the cells. Alice 5 10 15 20 thanks. |
Registering and logging in removes these ads.
LifeLock is the only Identity Theft Prevention Solution backed by a one-million dollar guarantee!Click here to get a 10% discount. Registering and logging in removes these ads. MultiSite SearchNavigationS/R TipsPopular content
Who's onlineThere are currently 0 users and 2 guests online.
|
NOTICE OF DISCLAIMER: All readers, visitors and/or users of this site is/are hereby given notice that any and all either express or implied views, opinions, suggestions, advice, product promotions, and/or any apparent statements of truths or facts that have been, presently are or in the future may be placed on this site are to be understood to be solely those of the party posting same. In no regard or event are any or all express or implied views, opinions, suggestions, advice, product promotions, and/or any apparent statements of truths or facts posted on this site in any way whatsoever to be either directly or indirectly understood, interpreted, construed or relied upon by any readers, visitors and/or users of this site as being expressed or purveyed by or representative of the host of this site, nor shall same be directly or indirectly understood, interpreted, construed or relied upon by any readers as an endorsement of same by the host of this site. Any and all such express or implied views, opinions, suggestions, advice, product promotions, and any/or apparent statements of truths or facts posted on this site should be thoroughly investigated independently by any and all readers, visitors and/or users of this site prior to relying or acting upon same in any way or at any time.
© 2005-2008 Speech Computing
Best Viewed at 1024x768 and higher resolutions
I'm not ultra familiar with
I'm not ultra familiar with MS-Speech, but on most speech programs I use the word "Tab" or "Tab Key" and "back tab" or "back tab key" (the quotes are not voiced) or similar to move from cell to cell in Excel.
Basically it should respond by saying the keystrokes you would use to do the same thing.
erm.is there any code for
erm.is there any code for the 'tab key' so that i can write it in macro? btw, im using microsoft speech recognition in excel.
thanks
On this, someone else will
On this, someone else will have to answer. We are now outside my knowledge of MS-Speech.
My guess is that the best
My guess is that the best thing MS-Speech users who want to write macros can do is wait for the arrival of Vista SR and the subsequent availability of its downloadable macro writing add-on -- then, presumably, writing application-based scripts will become as easy as it currently is for DNS Pro. As it is, Excel VBA doesn't seem suited for integration with MS-Speech.
However, I may be wrong about this idea, so maybe someone who knows better will be inspired to help you out.
Bruce
Bruce is right. This is
Bruce is right. This is possible with VBA in Excel with Speech Recognition, but it's not that easy to do in it's current form in Excel 2003. However, with the macro add-on to Vista that we're developing it would be incredibly trivial to create such a macro.
--
Rob Chambers [MSFT]
http://blogs.msdn.com/robch/default.aspx
Architect - Windows Speech Recognition - We're Listening...
This posting is provided "AS IS" with no warranties, and confers no rights.
There are no other solutions
There are no other solutions other than the vista?
There certainly are, they're
There certainly are, they're just not very easy to do. For example, you could use VBA to create a SpSharedRecognizer object, create a recognition context from that, create a grammar from that, then load that grammar object with an XML file containing what you want to speak, hook up an event handler for the recognition event, and then process the event by calling SendKeys when the recognizer tells you what was said.
That's probably about 50-60 lines of code or so. In the new macro system that we're developing, it'd only be a few lines (and much easier than programming in VB).
Are you familiar with programming in VB? If so, I can help point you to some samples that you might be able to derive from the specific solution you're looking for.
--
Rob Chambers [MSFT]
http://blogs.msdn.com/robch/default.aspx
Architect - Windows Speech Recognition - We're Listening...
This posting is provided "AS IS" with no warranties, and confers no rights.
im not very familiar wif
im not very familiar wif programming in VB. Is that other ways that you could help?
thanks.