excel - Can I use a variable to name other variables? -


i'm working on code requires lots of data stored , want write new data type these placed into.

     private sub commandbutton1_click()           dim myfile string, text string           myfile = application.getopenfilename()           open myfile input #1           until eof(1)              line input #1, text              'check see if line contains name              if instr(text, "name=") <> 0                  'trim down name                  text = replace(text, "name=", "")                  text = trim(text)                  'set current value of text name of new scalarin                  dim text scalarin              end if          loop      end sub 

i don't think works more understand idea. want happen read in name file , set name of new instance of custom data type.

public type scalarin     unitofmeasure string     value variant     source string  end type 


Comments

Popular posts from this blog

python - TypeError: start must be a integer -

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

django - Creating multiple model instances in DRF3 -