View Full Version : Read XSL(T) Files
DerbyNeal
04-06-2006, 07:23 AM
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
04-06-2006, 08:34 AM
Can you post an example of the file you want to read?
TonyJollans
04-06-2006, 11:24 AM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.