Guys,

I am trying to launch excel on a web server as a user. Not ideal I know, but its a temp solution until I get time to develop a better reporting mechanism.

Before I started messing with DCOM, I had excel installed on the server, when I went to launch Excel I was prompted for a login. If I login as domain admin my code runs fine, opens an excel template, dumps data from a dataset into the file, then saves it as an xls.

I was trying to get rid of the login when I came accross these 2 pages and I have implemented everything detailed in the first MSDN article.

http://support.microsoft.com/default...b;EN-US;288367
http://www.asp101.com/articles/jayra...et/default.asp


However, when I now try to run the code, excel.exe is starting as a process on the server, owned by the user (Identity impersonate is on), but Excel just hangs at that point and nothing more happens until I forcibily end the excel process.

I have no code in the xlt file, and opening it direct on the server I don't see any dialogue boxes that could be causing the hang.


Any ideas guys ?
Bob