I have a function that uses the following code:
Open "filename.csv" For Input As #1
Line Input #1, NRPI
For I = 1 To NRPI
Line Input #1, t$
Next I
For J = 1 To FNPI
Input #1, MWI, NPI, QS$, AA, BB
X1$ = QS$
For I = 1 To NPI
Input #1, TY, CH, MH, KH, DA
If (FNPI - J) 0.2 Then GoTo 10
TPI(I) = TY + 459.67: CPI(I) = CH: MUI(I) = MH: KI(I) = KH:
RHOI(I) = DA
10 Next I
Next J
Close #1
What I want to do is move the csv file to a sheet inside the excel
file. How would I go about doing this, and having it work through the
"lines" of the worksheet?