|
Subject:
|
Read XSL File
|
|
Posted By:
|
Neal
|
Post Date:
|
4/6/2006 9:01:55 AM
|
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
|
|
Reply By:
|
vemaju
|
Reply Date:
|
4/7/2006 6:47:37 AM
|
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
|
