RE: referring to increasing VBA variable name in loop
- From: sebastienm <sebastienm@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 28 Nov 2007 12:50:02 -0800
Hi,
Try using an array of strings:
'''--------------------------------
Dim i as long
Dim Phrase() as string
Redim Phrase(1 to 30)
Phrase(1)="Hello"
Phrase(2)= ...
...
Phrase(30) = "End"
''' speak
For i =1 to 30
XL.Speech.Speak Phrase(i)
Next
''' ----------------------------------------
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>
"ucdcrush@xxxxxxxxx" wrote:
I am using VBA to put together some phrases to be spoken with the text.
to speech feature in excel.
What I've got is a list of string variables,
Phrase1
Phrase2
Phrase3
....
Phrase30
which are set equal to different words or phrases such as
Phrase1 = "Hello"
I can hard-code a variable name into the speech code such as:
XL.Speech.Speak Phrase1
this will successfully speak the string assigned to Phrase1.
What Im having trouble with is referring to the Phrase1-30 variables
in a for loop, something like
for i = 1 to 30
xl.speech.speak phrase & i
next
This code doesn't produce any speech, I'm assuming because the
variable name isn't being passed as intended. How can I refer to
variables within a loop, when the loop # (i) is part of the variable
name?
Thanks.
- References:
- referring to increasing VBA variable name in loop
- From: ucdcrush
- referring to increasing VBA variable name in loop
- Prev by Date: Re: Add-In macro execution problem
- Next by Date: Re: referring to increasing VBA variable name in loop
- Previous by thread: referring to increasing VBA variable name in loop
- Next by thread: Re: referring to increasing VBA variable name in loop
- Index(es):
Relevant Pages
|
