>>>>I posted this message a week ago and received no reply. Assuming the message was missed and/or there actually is a method, I am reposting.
>>>>
>>>>Is there a way in VB to perform macro substitution like we do in VFP using the "&" operator?
>>>>
>>>>Thanks,
>>>>Bill
>>>
>>>I have the same question any time I have to use VB, and the answer is always 'No'. BTW, I've asked my friend (very good VB) right now.
>>
>>Hi Edward,
>>
>>That's too bad, and I'm quite surprised since I thought VB was an interpreted language like VFP which lends itself to macro substitution. Seems it would put real limitations on what can be done in VB. Do you know if VB developers have a workaround for this?
>>
>>Bill
>
>AFAIK, VB generic way is to use collections, fill them and then loop through if necessary.

Ok. Thanks Edward.
Bill