CreateObject(excel.application) run time error 429

[chas036]

I am trying to execute a VB executable on a SLQ 2000 server from a scheduled DTS task to create a new excel spreadsheet, and then to modify the columns of the same spreadsheet using VB code. I wrote the VB app on my machine, which has excel, and I tested it, and it works fine. I also included the Excel Object Library 8.0 when I compiled it.

When I put the EXEC version on the server (which does not have Excel on it) I get a run time error "429 Object can not be created" when it hits the line

Set App = CreateObject("Excel.Application&quot

What can I do to fix this? I can not install excel on the server.

 

[Gorth]

Hi,

This may be a little late but. . .

You have to have the application installed. It requires several VBA DLLs and other files as well as Excel.exe. VBA also requires the normal install of registry entries.

There is not a way around it.

Thanks!
-Gorth