Changes in Excel file by *.VBS script without Excel installed
 

Hi,

a need to automatically update Excel files (change sheets names) by VBS
script:

"Option Explicit
Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
objXL.WorkBooks.Open "c:\folder\file.xls"
objXL.Visible = TRUE ' Optional
objXL.Sheets("Sheet1").Select
objXL.Sheets("Sheet1").Name = "NewName"
objXL.ActiveWorkbook.Save
objXL.ActiveWorkbook.Close
objXL.Quit
Set objXL = Nothing "

on the computer without Excel installed. Is it possible? Are there any
libraries or something like this that can be installed instead of Excel
to run such script?

Changes in Excel file by *.VBS script without Excel installed
 

daniel,
OpenOffice ?

NickHK

"mentor" wrote in message
oups.com...
Hi,

a need to automatically update Excel files (change sheets names) by VBS
script:

"Option Explicit
Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
objXL.WorkBooks.Open "c:\folder\file.xls"
objXL.Visible = TRUE ' Optional
objXL.Sheets("Sheet1").Select
objXL.Sheets("Sheet1").Name = "NewName"
objXL.ActiveWorkbook.Save
objXL.ActiveWorkbook.Close
objXL.Quit
Set objXL = Nothing "

on the computer without Excel installed. Is it possible? Are there any
libraries or something like this that can be installed instead of Excel
to run such script?