Hi,

Is there anyway that I can use Excel VBA to read an XSL(T) file (line by line) and compare to a specified worksheet cell value?

Thanks in advance,

Neal

A Northern Soul

__________________
Neal

A Northern Soul

Hi Neal,

This code is from Excel VBA help

Dim TextLine
Open "TESTFILE" For Input As #1 ' Open file.
Do While Not EOF(1) ' Loop until end of file.
    Line Input #1, TextLine ' Read line into variable.
    Debug.Print TextLine ' Print to the Immediate window.
Loop
Close #1 ' Close file.


You can find this with keyword Line Input


-vemaju