vba I/O text

[BrianMH]

Hi,

Can any of the gurus here point me in the direction of a good reference for using I/O for writing and reading text files. I've been googling and found a few but would be interested if anyone has used a particular one that is quite detailed and helpful.

Also while a file is open for writing is there a way of returning the line number you are on?

Thanks

[Bob Phillips]

I think it is far too small a topic for a book Brian. I would suspect articles on t'interweb is the best source.

[BrianMH]

Thanks. Any idea on how to return the current line?

[Bob Phillips]

What do you mean by current line?

[BrianMH]

If I'm writing to a file and I might be doing this at different points instead of adding some sort of counter can I tell how many lines are in the file I have open for writing to.

[Bob Phillips]

Just open the file each time Append.