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. 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
if I had to stare at 500 lines like this
NA,Required,noSub,Policies and Procedures,94,$HasApplication - Policies and Procedures,P
I'd kill me too
My question is (and I know Im a total nub here) if I have this data in excel already
How do I
1) Open the worksheet
2) Read row by row and segment each column to the custom class's data member variables
3) 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)
4) know when to stop if the amount of rows increases
The custom class has these data members each representing a column of the excel sheet
Public Response As String Public Category As String Public SubCat As String Public Title As String Public Id As String Public Enttlmnt As String Public EntType As String
For 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. All things reference reading from a text file into and array in VBA not reading from XLS into an array in VBA.
Please help me?