You can write vb code in an Excel module. You can open an csv file like you would a text file. Use:

Open FilePath For Input As #1
Do Until EOF(1)
Line Input #1, strInput
DoYourThingWithstrInput()
Loop

something like this.
Hope this helps.