locked
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

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 01, 2008 7:06 AM