I have a very long CSV file (more lines than Excel can handle). Is it
possible to read and work with the data in the CSV file using Excel
VBA?

For example let's say my CSV file looks like this:

1,2,3
4,5,6
7,8,9

I'd like to be able to loop through the csv to the end of file,
reading each value into a variable that holds the running count of each
column (3 variables total).

Thanks so much.