View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mentor mentor is offline
external usenet poster
 
Posts: 2
Default 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?