View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OJ[_2_] OJ[_2_] is offline
external usenet poster
 
Posts: 111
Default Reading CSV file from Excel (VBA)

Hi Alex,
What are you trying to do here? This will open the file and load each
line into an array using VBs file access system...

Sub ReadFile()
Dim temp() As Variant, lngInc As Long
Open strFile For Input As #1
While Not EOF(1)
ReDim Preserve temp(lngInc)
Line Input #1, temp(lngInc)
Let lngInc = lngInc + 1
Wend
Close #1
End Sub

OJ