If I understand you, you can use FileSystemObject(FSO).
Open a reference to Microsof Scripting Runtime, and then....
Dim a As Scripting.TextStream
Dim b As Scripting.FileSystemObject
Set a = b.OpenTextFile("YourFile.csv")
This, put your csv file, line by line in a TextStream Object, then you can cut line in pieces (well, pieces separated by commas) using Mid, Left, and other VBA string functions.
Try it!!!
I hope help you with this.

German