Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Changes in Excel file by *.VBS script without Excel installed

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do something in an VBS script for all worksheets of an Excel file? Claudia d'Amato Excel Discussion (Misc queries) 9 June 26th 08 10:53 PM
Cannot open File on newly installed Excel 2007 Thank you. Terri Excel Discussion (Misc queries) 1 December 6th 07 09:49 PM
Save Excel File every wednesday VB Script Help !! sam76210 Excel Discussion (Misc queries) 0 March 8th 06 04:05 PM
Script to save Excel file to the server. raj41977 Excel Discussion (Misc queries) 3 December 8th 05 02:48 PM
An Excel environment started from a VB script .vbs file. Jerry[_11_] Excel Programming 0 July 15th 03 08:21 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"