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
Post a Comment