How do access Excel objects if excel is not loaded

[chas036]

I am trying to execute a VB executable on a SLQ 2000 server to create a new excel spreadsheet from data query to the sql database, and then to modify the columns of the same spreadsheet using VB code. I wrote the VB app on my machine, which has excel 97, and I tested it, and it works just fine. I made sure that when i compiled it into an executable, that I also included the Excel Object Library 8.0 .

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

How can I access excel objects without having excel loaded on the server?

 

[acron]

You will need to have a registered (in the Registry) copy of Excel on all target systems that will run your application.

I do not think that you can freely distribute the Excel object Library.

A.C.