All things reference reading from a text file into and array in VBA not reading from XLS into an array in VBA. The custom class has these data members each representing a column of the excel sheet Public Response As Stringįor question 4 I thought maybe I could start the 'A' cell of whatever number row it's supposed to stop to something like "$$$$" and then look for that to break a while loop, but again I don't even know how the while loop should look to start.I've looked online to no avail at all.
VISUAL BASIC FOR EXCEL ARRAY HOW TO
My question is (and I know Im a total nub here) if I have this data in excel alreadyĢ) Read row by row and segment each column to the custom class's data member variablesģ) Put that class into the dynamic array (which I think I know how to do, but maybe it's different when reading in excel I dunno)Ĥ) know when to stop if the amount of rows increases If I had to stare at 500 lines like this NA,Required,noSub,Policies and Procedures,94,$HasApplication - Policies and Procedures,P It turns out that reading from the text file (which will be updated and contain about 500 lines to start) is a hideous complicated looking process for anyone updating my project for the future I posted before about reading values from a delimited text file into a class with string properties, and then jamming that class into a dynamic array.