[OLE] NLS problem

2001-06-13 Thread Petr Smejkal
umbers and funtion but IT IS NOT WORKING $sheet-Range("A4:C5")-{Formula} = (['1.', '=2*1.5', '=IF(A40,B4,A4)'], ['1.2222', '=2*1.5', '=IF(A50,B5,A5)']); -- Petr Smejkal ___ Pe

RE: Help on subctitution s///

2001-06-07 Thread Petr Smejkal
open IN, 'in.xml'; open OUT, 'temp.xml'; while (IN) { s/\s*\/NAME/\/NAME/; print OUT; } unlink 'in.xml'; rename 'temp.xml', 'in.xml'; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saxena, Saurabh Sent: Thursday, June 07, 2001 1:16 PM To:

RE: evaluating an expression

2001-03-23 Thread Petr Smejkal
If the object is Win32::OLE object you could use Invoke method (see Win32::OLE doc) Or you could use eval: $temp = 'callmethod'; @param = ( 'a','b','c','d' ); eval "\$myobj-$temp(\@param);"; -- Petr Smejkal -- European Data Administrator -- Tesco / EuroIT / Business Systems -- Tesco

RE: urgent help required

2001-03-14 Thread Petr Smejkal
It looks more like run-time error from HTML::Parser. Are you sure that the content of your client's page is the same as your localhost page? -- Petr Smejkal -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vishal Madan Sent: Wednesday, March 14

Perl, Excel and missing SaveAs

2001-03-07 Thread Petr Smejkal
;temp.txt"), FileFormat = xlText, CreateBackup = 0 }); print "\n"; print (Win32::OLE::LastError() ) if Win32::OLE::LastError(); print "\n\n"; $book-Close({ SaveChanges =

RE: Preventing Browser-timeout

2001-02-21 Thread Petr Smejkal
have never contrived to do it). -- Petr Smejkal -- European Data Administrator -- Tesco / EuroIT / Business Systems -- Tesco HO Letnany, Veselska 636, 190 00 Praha 9 -- Office: +420 - 2 - 840 14 639 -- Mobile phone: +420 - 724 - 003754 -Original Message- From: [EMAIL PROTECTED

OLE Variant Variable

2001-01-04 Thread Petr Smejkal
can I set it to False but not 0??? # $sheet ... ActiveSheet $sheet-PageSetup-{Zoom} = 0; # has no effect -- Petr Smejkal -- European Data Administrator -- Tesco / EuroIT / Business Systems -- Tesco HO Letnany, Veselska 636, 190 00 Praha 9 -- +420 - 2 - 840 14 639

RE: Using vertical line as separator

2001-01-04 Thread Petr Smejkal
pipeline | is a valid control character in RE first split param is RE you have to eliminate the control meaning of pipeline ( \| or quotemeta | ) split (quotemeta $sep, $record)); # Works fine -- Petr Smejkal -- European Data Administrator -- Tesco / EuroIT / Business Systems -- Tesco HO