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

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

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top