Read XSL(T) Files

[DerbyNeal]

Hi,

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

Thanks in advance,

[Jacob Hilderbrand]

Can you post an example of the file you want to read?

[TonyJollans]

It's just a text file - something like this should let you read it ...Open "C:\MyTransform.xlst" For Input As #1
While Not EOF(1)
Line Input #1, MyLine
MsgBox MyLine ' or whatever
Wend
Close #1Once you've read it you can do what you like. If, however, you want to understand the file that could be a great deal trickier. Parsing free format text is quite involved.