On Sep 18, 3:09*pm, "Floyd" <vbsstr...@xxxxxx> wrote:Here's one way ...
> can anybody help me with a script.
>
> I want komma seperated textfile import it to excel, with a vbs script.
>
> the data is :
> computer, videocart,network
> computer01,videocart01,network01
> computer02,videocart02,network01
sFolderSpec = "C:\Documents and Settings\USERNAME\My Documents
\Somewhere"
sFilename = "testdata"
sFileSpec = sFolderSpec & "\" & sFilename
with createobject("Excel.Application")
.Workbooks.Open sFileSpec & ".csv"
.displayalerts = false
.ActiveWorkbook.SaveAs sFileSpec & ".xls"
.quit
end with
Tom Lavedas
===========
http://members.cox.net/tglbatch/wsh/


