Excel 2003 vba - readline from xls
Posted on 2010-08-27
ive got some code for reading in files via a macro written in excel 2003.
The code works really well on .txt. or .csv files
Set objFso = CreateObject("Scripting.FileSystemObject")
Set objFile = objFso.OpenTextFile("c:\balh.txt)
strLine = objFile.ReadLine
arrStrLine = split(strline,vbtab)
however, when i try and read in an .xks file, it goes wrong and the line comes out with smething like this:
strLine: ""ÐÏà¡±á>þÿ ,°þÿÿÿbãdåfçhéjëlínïpñrót õ v""
is this because you cant use this method to read in an xls file?
is there another way to read xls files?