Count Number of Records and Number of Fields in CSV File
 

I have a CSV File. I want to be able to - via VBA in Excel - count the
number of rows of data (i.e. records) and the number of Columns (i.e Fields).


Assuming you can create a count variable and loop through records. I am
using a "~" as a delimiter for my fields. Assuming I can use a count
function to count the number of ~ per record to get my # of columns. Unless
there is a better way to do this.

Any ideas?

Thanks

EM