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.
"Computers are incredibly fast, accurate and stupid. Human beings are incredibly slow, inaccurate and brilliant. Together they are powerful beyond imagination." - Albert Einstein
Reply With Quote
