I know that in VBA you use the opentext method, but when I use the following code in VBSCRIPT:<br>
<br>
call objXL.Workbooks.OpenText <br>
(FileName= "c:\Cache_Hit_Ratio.log", _<br>
Origin=xlWindows, _<br>
StartRow=1, _<br>
DataType=xlDelimited, _ <br>
textQualifier=xlNone, _<br>
ConsecutiveDelimiter=False, _ <br>
Tab=False, _ <br>
Semicolon=False, _<br>
Comma=True, _<br>
Space=False, _<br>
Other=False, _<br>
FieldInfo=Array(Array(1, 1), Array(2, 1), _<br>
Array(3, 1), Array(4, 1), Array(5, 1)))<br>
<br>
I get an error indicating:<br>
<br>
Wrong number of arguments or invalid property assignment (err code 450).<br>
<br>
Does someone know what's wrong with this vbscript code?
<br>
call objXL.Workbooks.OpenText <br>
(FileName= "c:\Cache_Hit_Ratio.log", _<br>
Origin=xlWindows, _<br>
StartRow=1, _<br>
DataType=xlDelimited, _ <br>
textQualifier=xlNone, _<br>
ConsecutiveDelimiter=False, _ <br>
Tab=False, _ <br>
Semicolon=False, _<br>
Comma=True, _<br>
Space=False, _<br>
Other=False, _<br>
FieldInfo=Array(Array(1, 1), Array(2, 1), _<br>
Array(3, 1), Array(4, 1), Array(5, 1)))<br>
<br>
I get an error indicating:<br>
<br>
Wrong number of arguments or invalid property assignment (err code 450).<br>
<br>
Does someone know what's wrong with this vbscript code?