Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to do something in an VBS script for all worksheets of an Excel file? | Excel Discussion (Misc queries) | |||
Cannot open File on newly installed Excel 2007 | Excel Discussion (Misc queries) | |||
Save Excel File every wednesday VB Script Help !! | Excel Discussion (Misc queries) | |||
Script to save Excel file to the server. | Excel Discussion (Misc queries) | |||
An Excel environment started from a VB script .vbs file. | Excel Programming |