Saving OpenText Excel file Using VBScript

Question

Got this script from the scripting guy, but having problems getting it to save without any interaction.  I want the script to open up a fixed field spreadsheet and save it as a .csv.    Just need a statement to save.  Thanks!

 

Const xlFixedWidth = 2

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.OpenText _
    "C:\Documents and Settings\User\Desktop\New Folder\Test1",,,xlFixedWidth,,,,,,,,,Array(Array(0,1),Array(12,1),Array(22,1))

 

objExcel.Quit

Answer 1

Hi,

 

This forum is for VB.Net questions only, sorry.

 

VBA, VbScript and all versions of Visual Basic up to VB6 ( Visual Basic version 6 )

are not supported in this forum area, sorry.

 

The VB which is built-in to Microsoft OFFICE applications such as EXCEL is known as VBA

 

Visual

 

Basic for

 

Applications

 

 

You might like to try the VBA forum too which is at.>>

 

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=74&SiteID=1

 

Please also try this page>>

 

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478161&SiteID=1

 

on there you will find other url links to click on to direct you elsewhere.

 

 

 

 

Regards,

 

John

 

Answer 2

Thanks John.

 

Answer 3

Hi Steve,

 

Welcome to the MSDN forums too.

Please mark any post(s) As Helpful or As Answer , as appropriate.

 

 

 

 

Regards,

 

John

 

Answer 4

Thank you John for your passional support and help!

 

Thank you Steve for your active participation in MSDN forums!

 

 

Regards,

Martin