Answered by:
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
Monday, January 28, 2008 6:01 PM
Answers
-
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
Monday, January 28, 2008 6:18 PM
All replies
-
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
Monday, January 28, 2008 6:18 PM -
Thanks John.Monday, January 28, 2008 6:27 PM
-
Hi Steve,
Welcome to the MSDN forums too.
Please mark any post(s) As Helpful or As Answer , as appropriate.
Regards,
John
Monday, January 28, 2008 6:35 PM -
Thank you John for your passional support and help!
Thank you Steve for your active participation in MSDN forums!
Regards,
Martin
Friday, February 1, 2008 7:06 AM