ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Object Model (https://www.excelbanter.com/excel-programming/398596-excel-object-model.html)

Darrin

Excel Object Model
 
Wonder if you can help....

I have a vbscript which I would like to run, which opens an Excel object,
refreshes some workbooks and saves the refreshed/updated versions. I would
like to run this on a server as a daily job, however I dont want to install
Excel on the Server. Is there anyway this can be done using Object
automation etc....

Thanks
Darrin


Jim Cone

Excel Object Model
 

http://support.microsoft.com/kb/257757/en-us
"Considerations for Server-Side Automation of Office"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Darrin"
wrote in message
Wonder if you can help....
I have a vbscript which I would like to run, which opens an Excel object,
refreshes some workbooks and saves the refreshed/updated versions. I would
like to run this on a server as a daily job, however I dont want to install
Excel on the Server. Is there anyway this can be done using Object
automation etc....
Thanks
Darrin


Jon Peltier

Excel Object Model
 
Automation opens the application in question and performs activities using
the instance of that application. Without having the application installed,
you cannot very well automate it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Darrin" wrote in message
...
Wonder if you can help....

I have a vbscript which I would like to run, which opens an Excel object,
refreshes some workbooks and saves the refreshed/updated versions. I
would
like to run this on a server as a daily job, however I dont want to
install
Excel on the Server. Is there anyway this can be done using Object
automation etc....

Thanks
Darrin





All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com