If Excel is not installed in cannot be done, as it is trying to use Excel in
the CreateObject.

--
HTH

Bob Phillips

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