access to variable via namestring 
Author Message
 access to variable via namestring

Hello together,

how can I access a VBA variable by its name ?

Background:
I receive the name of a variable, which I use in my VBA code,
from another application via a TCP/IP connection.
The other application send me the name of a variable in a string
and I have to send back the actual value of this variable (also
as string) to the originator.

Have someone any idea how I can access a variable (value) if I have
the name of it in another string variable ?

Thanks
---------------------------------------------------------------------
Jens Jung



Mon, 03 Nov 2003 23:32:44 GMT  
 access to variable via namestring
Try Eval().

Quote:

> how can I access a VBA variable by its name ?

> Background:
> I receive the name of a variable, which I use in my VBA code,
> from another application via a TCP/IP connection.
> The other application send me the name of a variable in a string
> and I have to send back the actual value of this variable (also
> as string) to the originator.

> Have someone any idea how I can access a variable (value) if I have
> the name of it in another string variable ?

--
Perth, Western Australia
Tips for MS Access users at:
        http://odyssey.apana.org.au/~abrowne


Tue, 04 Nov 2003 11:15:12 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Access VB Control via Variables?

2. Two Questions - Making a userform active / Accessing a userform via a variable

3. accessing sql variables via vbs

4. Connecting to Access via Visual Basic via Internet

5. Excel VBA - How to return multiple parameters/variables via a sub

6. Converting Access 97 to Access 2000 via VBA

7. attachments.add via variable or array

8. Calling subroutines via variables

9. Invoking a function via a variable

10. Dynamic mem allocation via array names as variables

11. Array stuff via arrays represented by variables

12. Accessing encrypted data in Access 2000 DB via VB

 

 
Powered by phpBB® Forum Software