Re: Win32 OLE Excel 2003 question

What is the value of $TRUE? I don't think it contains what you think it does.

I'm not aware of any good way of preventing orphaned copies of Excel except not crashing your script.

Comment on Re: Win32 OLE Excel 2003 question Download Code

Replies are listed 'Best First'.
Re^2: Win32 OLE Excel 2003 question by gibsonca (Beadle) on May 05, 2009 at 21:08 UTC
`So you don't have trouble with freezepane? Great I won't give up. $TRUE is 1, tried using the following: = 1 ; = '1'; = "1"; = $TRUE; Crashing is caused by the user having a copy of excel running, unrelat +ed to the script, when the perl script is run. The involved files are + unique. So it would be best to know that excel is already running before the s +cript is run. I could error out nicely, instead of locking up an orph +aned version of excel.` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Win32 OLE Excel 2003 question
by gibsonca (Beadle) on May 05, 2009 at 21:08 UTC

So you don't have trouble with freezepane?  Great I won't give up.

$TRUE is 1, tried using the following:

 = 1 ;
 = '1';
 = "1";
 = $TRUE;

Crashing is caused by the user having a copy of excel running, unrelat
+ed to the script, when the perl script is run. The involved files are
+ unique.

So it would be best to know that excel is already running before the s
+cript is run. I could error out nicely, instead of locking up an orph
+aned version of excel.
[download]

[reply]
[d/l]