Using Input statement to read from text/csv file

[KGee]

I'm using the input statement to read data from a CSV file. I need to retrieve the strings from the 7th and 14th fields in the file and assign them to variables. Is there any way to specify only the 7th and 14th fields so I don't have to bother listing the other 12 variables I don't need?

Input #1, var1, var2, var3...var14

 

[KGee]

Ah I see. That's what happens when you take everything literally. However I do think it would be easier to learn VBA if the commands were simplified to that level.

Thanks again.

 

[Ruddles]

I can't make up my own commands?

I always thought a ComeFrom command would be useful to drag one's code back on track when it gets a bit lost from doing too many GoTos.