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?

"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
--