Windows Vista Forums

How do i open Excel 2003 or 2007 from VBS

  1. #1


    RedV Guest

    How do i open Excel 2003 or 2007 from VBS

    I have both 2003 and 2007 installed on my machine. I want to create a VB
    Script to open a few files in 2003 and in 2007 versions. How can i do that?

      My System SpecsSystem Spec

  2. #2


    Richard Mueller [MVP] Guest

    Re: How do i open Excel 2003 or 2007 from VBS


    "RedV" <RedV@newsgroup> wrote in message
    news:860341B7-8D6F-4227-8361-F6135080CDA1@newsgroup

    >I have both 2003 and 2007 installed on my machine. I want to create a VB
    > Script to open a few files in 2003 and in 2007 versions. How can i do
    > that?
    VBScript code similar to below should work for either version, as long as
    the 2007 version is installed on the computer where you run the script:
    =============
    Option Explicit
    Dim objExcel, objWorkbook

    Set objExcel = CreateObject("Excel.Application")

    ' Open either 2003 or 2007 version Excel spreadsheet.
    ' objExcel.Workbooks.Open "C:\Scripts\Example.xls"
    objExcel.Workbooks.Open "C:\Scripts\Example.xlsx"

    Set objWorkbook = objExcel.ActiveWorkbook.Worksheets(1)

    ' Display some specific cell values.
    Wscript.Echo objWorkbook.Cells(1, 1).Value
    Wscript.Echo objWorkbook.Cells(1, 2).Value
    Wscript.Echo objWorkbook.Cells(2, 1).Value
    Wscript.Echo objWorkbook.Cells(2, 2).Value

    ' Clean up.
    objExcel.ActiveWorkbook.Close
    objExcel.Application.Quit

    --
    Richard Mueller
    MVP Directory Services
    Hilltop Lab - http://www.rlmueller.net
    --



      My System SpecsSystem Spec


How do i open Excel 2003 or 2007 from VBS
Similar Threads
Thread Forum
Excel 2007 cannot open file under Vista Business Vista General
Can't open Excel 2007 with double click Vista General
office excel 2007 & 2003 on same computer? Software
Excel 2007 display shift when open file in explorer Vista General
Excel 2007 wil not open and Excel 2007 document in Vista? Vista General