Append Number to Variable Name?

[CrazyFileMaker]

Hello,
My question is about appending a number to a variable name.

I know you can append both a number and variable's value to a string. I do this in the message box in my example below.

However, is there any way to append a number to a variable name?

My code for doing so in the following example does not work. But I was wondering if there was any possible way. The following example demonstrates a scenario in which it would be helpful.

Please Login or Register  to view this content.

[PingPing]

I could be wrong, but I don't think you can change the name of a memory location's pointer in VBA.

[romperstomper]

You can't do that. What you would do is use an array in the first place.

[Richard Buttrey]

Hi,

It's not clear, at least to me, what result you expect to see in the message box.

There seem to be one or two problems at first glance but it's difficult to comment without knowing exactly what you want.

For instance your initial variable declaration only declares sName3 as a string, the other two are variants - which may not matter in this case but can give unexpected results. You can declare several variables on the same line with one Dim statement, but each one should be explicitly defined. e.g

Dim st1 As String, st2 As String, iNo as Integer ....etc

Then your line ReDim Preserve sNameArray(i) As String seems to be trying to change the (numeric) dimensions but as a string. Then in the next line sName hasn't been defined, neither for that matter has i.

Tell us the result you expect and no doubt we can help. If this is a single example and there are other variables in the real world enhance your example to cover at least two or three situations.

Regards

[dominicb]

Hi CrazyFileMaker

Just as a point of interest, your line :

Please Login or Register  to view this content.

would only type varaible sName3 as string. You must type each one individually, thus :

Please Login or Register  to view this content.

HTH

DominicB

[ajm218]

Had the same problem a while ago - turns out the solution is pretty trivial once you find out about the Evaluate() function

Please Login or Register  to view this content.

[romperstomper]

Did you actually try that? It won't work.

[pike]

Maybe

Please Login or Register  to view this content.

[CrazyFileMaker]

Hello all,
My thanks to all of you for your helpful feedback!

I apologize for the hurried code and my faulty string declaration. The program in which I faced this problem is much larger, the situation more complex. I was trying to simplify both in an effort to be clear, but did so in haste.

On another note, Pike's example was just what I was looking for! I won't bore you with a lengthy example as to why an array wouldn't suffice in this case - I'll just say that it would have cost me much time in the way of recoding my modules. On top of that, Pike's helpful example has also greatly reduced the final line count in my code!

Thanks again to all of you! And I think I owe Pike a special thanks for his outside-of-the-box solution! Thanks Pike!