A OLE question

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

i used Perlscripts for control MS-OLE-Excel reading and writing
the scripts ran successful. and close the OLE at the end line in scripts. all things seemed in working order.
but when the next time i ran the same scripts again, excel program could not be start .
i tried manual started the excel program then got the same problem. at last, i restarted the win2000(my operating system) and problem disappeared, every time i met this problem after i had ran perl OLE scripts once. what is the problem? did i have not clear up the memory since the ole have started?
thanks

Comment on A OLE question

Replies are listed 'Best First'.
Re: A OLE question by Jenda (Abbot) on May 27, 2003 at 20:52 UTC
Could you try to add `$excel->{Visible} = 1;` [download] just after you create the $excel object? Does the Excel disappear when your script finishes? Are you able to start Excel once you manualy close the one created by your script? Are there any dialog boxes opened by the Excel that you need to close manualy? And last ... please show us some code. Jenda Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. -- Rick Osborne Edit by castaway: Closed small tag in signature	[reply] [d/l]
Re: A OLE question by artist (Parson) on May 27, 2003 at 16:15 UTC
Hi rootstock, can you post small snippet of your code? Also if you are just reading and writing you can use Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. artist	[reply]