Excel Win32::OLE->Uninitialize

rpike has asked for the wisdom of the Perl Monks concerning the following question:

Thanks to Ted Young who gave me this method. However, I was having some problems with a user trying to initialize the Win32::OLE->GetActiveObject method (trying to grab Excel.Application). I didn't realize the appropriate permissions had to be set on the DCOM service running (that fixed that part). But where there is (I guess) Windows authentication going on and a non-administrative user logs to the site (cgi script in Perl, in this site of course) the Win32::OLE->Uninitialize doesn't work. Any suggestions on what else I may have to do? Thanks again wisdom warriors...

Comment on Excel Win32::OLE->Uninitialize

Replies are listed 'Best First'.
Re: Excel Win32::OLE->Uninitialize by Corion (Patriarch) on Jan 12, 2006 at 13:52 UTC
Please try to be more specific. For example, tell us, how the `Win32::OLE->Uninitialize` method fails for you. Also, consider telling us what problem you are trying to solve by using it. Some small example code which reproduces the problem always helps. My guess is that this is a permissions issue because your webserver is configured to run as a user that has no permission to access OLE objects. Usually, this is a very good idea.	[reply]
Re^2: Excel Win32::OLE->Uninitialize by rpike (Scribe) on Jan 13, 2006 at 14:51 UTC
I had already posted a question regarding this but a different problem (i.e. the solution to the question lead to me asking another question and using Uninitialize). I've posted the code there already. The reason for this post is to 1) give this particular question the proper subject and 2) allow to be pushed to the top of the list because the question area has changed slightly. Anyone who had already looked at it may think it unrelated to what I had posted earlier. Here's a suggestion to the adminitrators: could you promote the last responded to questions to the top of the listing? It would make looking for replied to recently questions much easier. Any help regarding this question would be much appreciated. thanks. Rob Here's the code: Re^2: Excel exe still hanging 'round	[reply]