I would expect this would only produce a result when there was a True in column A, and all of the results would end up with you going to the beach. I'm not clear if you are doing this from within Excel, if so you don't need to set a reference. If not, then yes, you will need it.
Reverend Paulson replied to wally eye on Apr PM. I must have the beach on my mind since my code sent me there. You were absolutely correct and I'm 'up and running'. Again, a large thank you, may many points be awarded to you, and a trip to the beach be in your near future as well. The following example assumes that you type text in your Word document and then select the text before you run the Sub procedure. The actual problem is that the reference to Microsoft Scripting Runtime is missing.
If you are unable to find the Microsoft Scripting Runtime then probably the library is missing. Once downloaded the scrrun. You're most welcome, and I'll bring the umbrella! I usually figure out the answers to my problems from previous post, so I'm not certain on the proper protocol for thanking everyone for the generous kind offer to relieve my hair pulling and frustration, most people just do a "pre-thanks".
If everyone in the world took the time to help another as you all have with me, this would be one wonderful place to live. I apologize if this was not the proper way to thank you, i assure you, if it's wrong it was unintentional, as my sincerity is pure. Parag Satpute, turning on Microsoft Scripting Runtime, did not fix my problem.
Both you and Wally Eye suggestion of validating for True and Salesman is correct. Item cmbVoices. SelectedIndex oVoice. Value oVoice. Speak txtSpeach. Text, SpeechLib. EventArgs Handles MyBase. Count - 1 arrLst. Add arrVoices. Item i. GetDescription Next cmbVoices. Click flTxtFile. StreamReader flTxtFile. FileName txtSpeach. ReadToEnd strmRedr. EventArgs Handles btnSavetoFile. SpFileStream cpFileStream.
Open SaveFileDialog1. FileName, SpeechLib. Most likely, a member posted a link a long time ago to a web page that has since been removed.
It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post. Print Voice. Speak Text1. Hope this Helps. Haven't tried it, but I hope the link will work. There are two different OCX controls. The first two you get by checking the boxes to add those fancier OCX controls. DLL and VText. DLL or something quite similar.
But there's no OCX control. Project - References. Once checked it pops nicely to the top. I'm posting this hoping you will find that more easily than I.
0コメント