Variable that is a Variable

[Jlomers]

I am not sure how to best describe this but my system pulls the middle initial from excel and is to type that initial into another program. However, when the initial is also a variable the system send the second variable rather than the initial.

Example: John Y Smith

XLGetCell>File,Sheet1,k,9,Init
Elsewhere in the system Y=0

When
"Send>%Init%" is used its send 0 instead of Y

It works if the initial is A C D because those are not variables, but Y or K don't because they are.

I thought the %Init% would prevent this?

[Marcus Tettmar]

I think the simplest solution is to use a different variable naming system. So e.g. instead of using Y as a loop counter (or whatever it is being used for) use something like varY. Maybe it's a position, so use posY or something like that. You're much less likely to get a clash that way.