Registering and logging in removes this ad.
Registering and logging in removes this ad.
Speech recognition in excel macros
Submitted by ameliaeng on Tue, 07/11/2006 - 16:57.
hi,
is there any way to have inputs from speech recognition to be input in excel macros?
or is there any good websites that teaches speech reocgnition for excel macros?
thanks=)
ameliaeng wrote: hi, is
hi,
is there any way to have inputs from speech recognition to be input in excel macros?
or is there any good websites that teaches speech reocgnition for excel macros?
thanks=)
Be glad to point you in the right direction or even answer your post directly. However, your statement of the problem is vague.
Can you be more specific (i.e., clearly define what it is that you want to do)?
Chuck Runquist
Former DNS SDK & Senior Technical Solutions PM for DNS with Lernout & Hauspie (L&H)
opps. my apologise. what i
opps. my apologise. what i meant was..
i wanted to write a macro that finds a word said by a user. is there any code to write it? in the sense, the code reads in the word by user instead of hardcoding it or typing it out?
for e.g.i want to find a word like "hello" in the spreadsheet. i know ctrl+ F is the [find] but i want to find through speech recognition. in the sense, when the user say something.. the macro would automatically takes in the spoken word and find the word he said.
and also,
is there any recommended links so that i could reference up on VBA in Excel Macros?
thanks=)
In the unimacro package, on
In the unimacro package, on top of natlink/natpython, there is a possibility to search for letters in any program (as far as implemented).
For Excel the search function is implemented in internal Excel routines, like VBA, but called from python (unimacro).
Looking for words is also possible through this grammar, but in practice the recognition is very slow.
You can look in: unimacro searching for more details.
Quintijn
It seems like you might just
It seems like you might just want to call up the Excel Find function and input what you want to search for via speech? Is that it?
If so, there a several ways to proceed. You can write a keystroke macro that types "Ctrl+f", which should call up the Find function. You can also write an Excel VBA macro that calls up this function and then write a Dragon Pro script that invokes this function, etc. You can also use other script systems, like Natlink/Vocola, Unimacro, etc.
What you need to do is say exactly what you want the user to be able to say and exactly what result you would expect. For example, you might be looking for general wrapper for the Find function so that the user can say "find me 'three apple in a poke'" and this command would invoke and run the Find function with the value "three apples in a poke" as its value and with the default Find function options -- or maybe with specified option values.
In other words, we're like a bunch of idiots savants -- you have tell us in brutal detail the exact scenario -- except maybe we ain't exactly up to snuff on the "savant" side of things
Bruce
yea! you guys get what i
yea! you guys get what i mean. but, i've got no idea what is keystroke macros, dragon pro script, Natlink/vocola,unimacros. I'm kinda a beginner in such stuff. so, really appreciate if help is given=).
i've tried recording a macro by just pressing ctrl+f. in the sense, just plainly record a macro> ctrl+f> stop recording(without saying anything that i want to find). and when i try to play back, it doesnt pop out the [find]. in fact, there isnt any movement. but if i record the macro with a word for it to find, meaning record a macor> ctrl+f> 'hello' being input in the textbox> find next> stop recording. and i play back, it would search for 'hello'.. but what i want was when the user say [find], the macro would to just pop out the [find] window and let the user say the word itself and when the user says[find next] it will find the word.
could u say..teach me how to write it or tell me any links(websites) that i could reference or give me an example or.. i dont know.=(
thanks=\
What version of DNS do you
What version of DNS do you have? Probably not Pro because that has a programming capability built into it. So that means you'll need to look into NatLink/Vocola or Unimacro. I don't use either one of those, so I'll let someone else give you some links and guidance.
Good luck!
Bruce
hi, whats DNS? i dont think
hi,
whats DNS? i dont think i'm using that.. I'm using the speech recognition in Windows XP language bar and the one in Excel 2003. yup. Thanks for your help! =))))
Are you using Dragon
Are you using Dragon Naturally Speaking (a commercial software package that does speech recognition), ViaVoice (similar to Dragon Naturally Speaking, but made by originally made by IBM, now sold by the same company that sells Dragon Naturally Speaking), or are you using the speech recognition feature included with Office?
If you're using speech included with Office, I can give you some pointers, or perhaps even write the macro for you as an example that you can build from ...
I think everybody on this board would love to help, we just need a little more info...
--
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.
thanks everybody! so nice of
thanks everybody! so nice of u all.=)
I'm not using any speech recognition software actually. What i'm using is just a normal microphone, the language bar(speech recognition) of window XP, microsoft excel 2003 and the speech function inside excel 2003.
yup. any other info do i have to give?
Mr rob chambers, could you please please please give me some pointers and write an example?
thanks ! =)))
Sure thing. Before I do
Sure thing.
Before I do that, I want to make sure I completely understand what you're trying to accomplish. I think you want to do this:
You: Start Excel
Excel: Starts
You: Say, "Find"
Excel: Find dialog pops up
You: Say, "something"
Excel: "something" is entered into the Find dialog
You: Say, "Find Next"
Excel: Finds the next occurrence of the phrase "something"
Yes?
--
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.
yup!=)
yup!=)
Time has a way of getting
Time has a way of getting away from me sometimes.
I did some investigation and I found out that the Find dialog in Excel doesn't support dictation in Office 2003. Not all areas in Office 2003 really support dictation, due to a lack of the application supporting some key interfaces programatically. Thus ... You won't really be able to do your scenario exactly as we talked about.
I'm going to think about this a bit and see if there's another solution, but I fear that there really isn't on XP. However, on Vista, this would be a trivial macro to write with the new Vista based Speech Recognition and it's (currently-in-prototype-stage) macro system.
--
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.
oh ok. thank you very much=)
oh ok. thank you very much=)