|Now, on to the individual concerns.|
nbrane: . . . but the argument needed the fully qualified path to the xls file.
We know it found the XLS file because it failed on line 18, well after it started using the spreadsheet. If it did fail to find the file, the script would probably silently fail, what with the If wb = Nothing check and all.
The great thing about scripting (and programming) is the ability to find out by asking the language itself.
For Each arg In WScript.Arguments
Next 'argNow you can save that, then drag and drop some files on it, and see exactly what Explorer passes as arguments. For a fun time, drop 200+ files on it. Personally, I suggest you do this to someone else's PC, so you can wonder off when you get bored.
ww4cash: Apparently you can't have a filename with spaces in it.
You can if you drag and drop. Use the fixed version.
ww4cash: excel has a limit of 255 characters
Newer versions have a limit of 32,000 characters.
ww4cash: [I]s there a limit on characters? . . . [I]s there a limit on the number of lines?
If there is, I can't find it in the documentation. Narrator was intended to assist the sight-impaired people who use Windows, so it'd have to be designed to handle the largest of web pages. As for lines, your hard limit is the amount of hard drive space you have.
ww4cash: [I]s there any choices in Voices?
You'd have to buy them, I think. Look for voice packs compatible with Vista/Win7's narrator. You'll need to set the voice you want to use as the default, because this script uses the default voice.
ww4cash: I am not sure what the speech portion does if it sees something in the record it can't deal with.
It tries its hardest and moves on. Remember this was designed for people who can't read the screen. "I don't know how to pronounce this," and stopping half way though really isn't an option.
ww4cash: Is there a document I can read that would tell me the rules for the text portion?
I haven't seen one, but I haven't looked. I suggest using Google.
ww4cash: Are there some switches that can set it to these wav parameters?
The script sets the format type to 34, which is SAFT44kHz16BitMono. You can play around with the values yourself, the official list is here. Try 35, 36, and 37, and see if you get a version your program will like.
How To Ask Questions The Smart Way