I am new to Visual Studio and more experienced with VBA.
Let's say I have a file called test.csv in c:\myfiles which has 3 lines
1,antelope,55
2,bear,44
3,cat,33
How can I open this file as read only and then, say, display in a msgbox the word "bear" as the second item in row 2. I believe I should be using ADO to do this, but need some help to get it working
It should be noted that some of the .csv file I wish to open for real can be quite big files (say, up to 10000 lines)
Thanks
Phil
Start Free Trial
