win32::ole (excel) question

2007-08-10 Thread dkazatsky
Hi all, Weird situation with creating new worksheets and keeping the title in the tab. I f I create just one everything is fine - when I add a second worksheet to the workbook the title goes away from the original worksheet. Code excerpt: This is where the object is instanciated and the first

RE: win32::ole (excel) question

2007-08-10 Thread dkazatsky
Hi Jan, You're abolutely right - I forgot I had changed the name I was using to set Sheet1. I changed to a shorter length and it's running perfect. Thanks much. Dave Kazatsky Senior Middleware Engineer NSE - Solutions Engineering W. (732) 893-4351 C. (973) 865-8106

Re: Help with DBD::DB2 *Resolved

2006-04-21 Thread dkazatsky
Thanks to everyone for their responses. The instructions for the new location of the .ppd available on CPAN works perectly. Dave Kazatsky Senior Middleware Engineer NSE - Solutions Engineering W. (732) 893-4351 C. (973) 865-8106 D D Allen [EMAIL PROTECTED] D D Allen [EMAIL PROTECTED]

Help with DBD::DB2

2006-04-20 Thread dkazatsky
Hi Perlers, We are moving some scripts to a new server (Win2k3) and are getting some errors with DBD::DB2 (can't locate DBD:DB2:Constants). I am trying to reinstall but the ppm site that used to exist (esoftmatic) doesn't appear to be operational. This machine does not have a C compiler so I

Re: breaking out of a for/foreach loop...

2006-04-18 Thread dkazatsky
Bruce, You can use a Label and a goto statement. for (@array) { if (condition met) { goto Label; } } LABEL: ... Hope this helps. Dave Kazatsky Senior Middleware Engineer NSE - Solutions Engineering W. (732) 893-4351 C. (973) 865-8106 bruce [EMAIL PROTECTED] bruce [EMAIL

RE: Win32:OLE Excel

2005-08-04 Thread dkazatsky
David, I have a script with almost the exact same code and it works correctly. Try removing the parens from your add statement and see if that makes a difference. Original Code: $Worksheet = $Workbook-Worksheets()-Add(); $Worksheet-{Name} = test $i; Becomes: $Worksheet =