|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
09-18-2008
| #1 (permalink) |
| | Re: data into excel On Sep 18, 3:09*pm, "Floyd" <vbsstr...@xxxxxx> wrote: Quote: > 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/ |
My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| how can i determine the excel rows that contain data | PowerShell | |||
| How to format numerical data that is exported to excel. | PowerShell | |||
| Re: data into excel | VB Script | |||
| populating two dimensional array with excel data | VB Script | |||
| excel data | Vista General | |||
