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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
names of variables in array
I think you would be better using a collection, they provide an indexed set
of values, you can control how the data is manipulated. Also collections do not allow duplicate keys something that would be an issue if not controlled. -- Regards, Nigel "David" wrote in message ... 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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
names of variables in array
Thanks Nigel
Ok, I'll store my keywords as collection items Say I have an item, "myABCkeyword" and I use it to search out a line of data from a text file. Once I find the data I want to assign the data to a variable called "myABCkeyword" or something like "_myABCkeyword" (ie: "_" & itemname). Can I force the item name (or "_" & itemname) to become the name of a variable? Thanks Again "Nigel" wrote: I think you would be better using a collection, they provide an indexed set of values, you can control how the data is manipulated. Also collections do not allow duplicate keys something that would be an issue if not controlled. -- Regards, Nigel "David" wrote in message ... 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" |
Reply |
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 |