ActiveX component can't create object: 'Excel.Application'

Hi,
I have sql stored proc that creates a bunch of CSV's and saves the results to a separate server.
At the end of the SQL script I execute a VBScript to consolidate the csv's based on some parameters.
The server where the CSVs are saved has excel installed. The server where the SQL proc is executed does not have excel installed.
When the VBScript is executed, the folder structure is created, however I get the following error:
Microsoft VBScript runtime error: ActiveX component can't create object: 'Excel.Application'

Any thoughts on how to complete this process without installing excel on the SQL server would be greatly appreciated.
Thanks!

Sorry, the Script is saved on the Excel server where the files are being saved.
I am executing the VB Script as part of my SQL server stored procedure which is being executed on the SQL Server.
So Execute Stored Proc on SQL Server, files are saved on Excel Server. Then from the SQL Server I execute a VBScript that is stored on the excel server.

Perhaps you must state the server name in the CreateObject function

Please Login or Register  to view this content.