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.
|
Results 1 to 2 of 2
Thread: Excel .CSV filesThreaded View
|
Click Here to Expand Forum to Full Width |