Open File

[rick32]

I need help in openning a file (grades.txt) where I could put them in rows and columns ? so, I could compute average grade per student,average for all students and average per test (T1,T2,T3)

Name T1 T2 T3

Mark 98 97 96
James 99 95 91
Robert 90 92 93
Kevin 99 91 90
Ed 98 90 94

:-(

 

[MikeAngelastro]

Dim Average as Double
Dim A$ as String

Open "Grades.txt" For Input As #1
Do until EOF(1)
Line Input #1, A$
Average = ParseAndAverage(A$)
Loop

Then write a function to parse and return the average of each A$.