VB6 - Concatenate Variable Names???

why not use an array?

Dim str1(4) as String
Dim str2(4) as String

for i = 0 to UBound(str1)
  str1(i) = "Hello"
next

for i = 0 to UBound(str2)
  str2(i) = "Everybody"
next

Because some of the variables are arrays already! And I want to use the same function to download my 4 different files which have variable data but same layout!
Does this make sense?

dim myStr as variant
dim str1(1) as Variant
dim str2(1) as string

myStr = str1

str2(0) = "Hello"
str2(1) = "Everybody"
myStr(0) = str2

str2(0) = "Try"
str2(1) = "This"
myStr(1) = str2

myStr(0)(0) will equal "Hello"
myStr(0)(1) will equal "Everybody"
myStr(1)(0) will equal "This"
myStr(1)(1) will equal "This"

SilmaraFlor, basically, the answer is "no"  Once you compile a project, it loses the information about the variables, so concatenation of variable names becomes meaningless.

One way around this, as mentioned above, is to build the variables into multi-dimensional arrays.

Another way is to convert them into collections which are essentially arrays of unrelated items.

Please maintain this open question:
https://www.experts-exchange.com/questions/20329554/Multiple-step-OLE-DB-operation-generated-errors-Check-each-OLE-DB-status-value-if-available-No-work-was-done.html

Anthony

Thank you all for your responses.
inthedark,
Thank you for your examples, they helped me a lot.

I love user defined types becuase they are fast to use.

I think most of the examples would work but there was a syntaxt error here:

FileSpec.DataFromFile=Split(Input(FH,LOF(FH)),VbCRLF)

Should have been:

FileSpec.DataFromFile=Split(Input(LOF(FH), LH),VbCRLF)

Have fund, thanks....