M
mentor
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?
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?