Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOWTO: import comma delimited textfile in excel using VBSCRIPT?

Status
Not open for further replies.

mpmu

Programmer
Dec 2, 1999
1
US
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= &quot;c:\Cache_Hit_Ratio.log&quot;, _<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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top