Hi all

I'm writing my first Excel/VBA macro, and having some trouble doing a
certain function. I know this is probably really basic stuff, but in
all my searches I haven't been able to find any documentation on
deleting text file lines. The data in the text file that I have to
import into excel is in the following format:

# aaaaaaa bbbbbb ccccc
# aaaaaaa bbbbbb ccccc
# aaaaaaa bbbbbb ccccc
# aaaaaaa bbbbbb ccccc
Aaaaaaa bbbbbb ccccc
Aaaaaaa bbbbbb ccccc
Aaaaaaa bbbbbb ccccc
Aaaaaaa bbbbbb ccccc
# aaaaaaa bbbbbb ccccc
# aaaaaaa bbbbbb ccccc
Aaaaaaa bbbbbb ccccc
Aaaaaaa bbbbbb ccccc

The lines that begin with '#' are comments, and don't need to be
imported into the worksheet. The rest of the lines do. How do I go
about writing a do-while loop that will delete the comment lines? I
know how to program in Java pretty well, so I know the logic behind
this process, I just don't know the vba language. Not that it makes
any difference, but the fields are tab delimited, so the file is
displayed nicely in excel once it is imported. All I have left is
deleting those comment lines, any help you guys can give me will be
hugely appreciated.

Thanks in advace,

Roman