Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
string variables in file names | Excel Programming | |||
Inserting variables within file names | Excel Worksheet Functions | |||
Passing Worksheet Names as Variables | Excel Programming | |||
Sub Routine Names As Variables | Excel Programming | |||
variables for file names | Excel Programming |