Excel object not created when running as a different user

[jday05]

I have a program that creates an Excel spreadsheet and then saves it. I've compiled it and it runs with no problems on my computer. I've set it up as a scheduled task on my computer under my id (my computer is on an active directory domain), and it works properly. The problem I've run into is when I set the scheduled task to run under a different user id. When I do this, the program starts, but once it gets to the point of creating the Excel application object, it doesn't do anything. The program is still running, but at that point it is effectively stopped.

I've tried using 'Set xlsApplication = CreateObject("Excel.Application")' and 'Set xlsApplication = New Excel.Application', but the program stops in at the same position either way. The user I'm trying to run the program as has a profile set up on the computer and is able to login and run the program with no problems. I am also able to run the program successfuly using the "run as..." service. Any idea why the Excel application is never opened/created?

 

[MrPtt]

Hi
If it's an ActiveX, you could configure DCOM and make it run with your user. (You say it works fine so)

What do you think?

Good luck!
;-)