well i figured out the error

[jasonseay]

Access denied attempting to launch a DCOM Server using DefaultLaunchPermssion. The server is:

{00024500-0000-0000-C000-000000000046}

The user is NETWORK SERVICE/NT AUTHORITY, SID=S-1-5-20.

 

 

 

 

This is the error in the System log that occours everytime i try to run the program

 

you have to go to a command line and type

 

dcomcnfg.exe

 

go into component services

 

 

find microsoft excell and grant asp.net account the rights to open a dcom application.

 

 

this is on 2003 server.