View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default names of variables in array

I am using a set of keywords to get data from a batch of text files
i can load the keywords into an array at the start of the program
and then use each one to sequentially search each text file in turn
Can I convert the array contents to names of variables and vice-verca?
(Would make code very compact)

Dim kwd1 As Double, kwd2 As String
myarr = Array("kwd1", "kwd2")
ConvertedToVariableName(myarr(0)) = 50.1
ConvertedToVariableName(myarr(1)) = "mystring"
MsgBox kwd1 'returns value 50.1
MsgBox kwd2 'returns string "mystring"