Speech / Voice prompt solution

[diageminc]

Hello,

We sell products, and every morning we print a "pick list" (column A has "item#" and Col B has "Qty") and then the worker goes into the warehouse and pick the items. Currently she holds the sheet in one hand and reads and uses the other hand to pick the item.


We are looking for a solution that will read the items to her, this way both her hands are free to pick. We thought of using Excel's text to speech, but from what i understand we cannot use voice prompts to control give control commands to pause, repeat or stop the read back.


Any ideas?

diageminc

 

[Logit]

.
Paste this macro into the Sheet Level Module :

Option Explicit


Sub Check_Speach()
  'Read Data from Excel Sheet
   Application.Speech.Speak Selection                   
End Sub

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

1​

[/td][td]Well, hello Dolly. Hello, Dolly. Its so nice to see you back where you belong.[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]This is a test 1[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td]This is another test[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]Pull Row 2, Left side, Shelf 15.[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td]Time for a break.[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]
As you can see from the above shot of the excel sheet, the user will need to click on the row/cell to be spoken.
Then they click the command button to run the macro. Excel speaks the text and stops.

They then move to the next row and repeat.

HTH

 

[diageminc]

Thank you for the solution. I am sorry i was not able to explain the issue more clearly. The user doing the picking will not be able to run to the computer and click each time, the text to speech should start and read each row and stop and with a voice command such as "next" it should read the next row