Automate Excel/Powerpoint On Server Without MS Office

[ApocY85]

My team has an Access DB file that was used for automating an Excel to Powerpoint process via VBA. I recently made a VBScript version hoping that we no longer would need to open the Access file and click a button to start the process. I also had hopes to schedule the script to run on a server. However, to my knowledge, MS Office is not installed on the server. So, when the script-execution reaches lines such as:

Set oPPTApp = CreateObject("PowerPoint.Application")

the script fails. Is there any way to get by this without having Office installed on the server? My guess is no, but I thought I'd hear it from a few experts

Thank you in advance for your responses!!

 

[kss444]

The simple answer is to install the office products that you need.

The harder way would be to get all the required dll's and register them on the pc.

Ordinary Programmer