Excel Object Model

[Guest]

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]

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]

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