Re: OLE methods with output arguments

2002-11-26 Thread Jan Dubois
On Fri, 22 Nov 2002 10:37:52 -0500, "Jon Vinson" <[EMAIL PROTECTED]> wrote: >Figured it out. Answer: Variant(VT_VARIANT | VT_BYREF, Variant(VT_EMPTY)) > >(Good grief!) Yes. But then, passing arguments by reference is rarely done in OLE Automation. Anyways, I've added a "shortcut" (for some v

RE: Excel to html format

2002-11-26 Thread Harald Wopenka
Title: Excel to html format Maybe you should use Excel's built in Visual Basic for that task. You can open a workbook including a auto_open macro that grabs your desired information and writes the HTML-File. And you don't have to take care about your version of Excel since VB in every versio

Re: thread limit in fork?

2002-11-26 Thread prefab
I am using ActiveState Perl 5.6.1 build 633 on w2k workstation. --- Scott Carr <[EMAIL PROTECTED]> wrote: > Which OS are you using? > -- > Scott Carr > Documentation Maintainer > http://documentation.openoffice.org > OpenOffice.org > > > Quoting prefab <[EMAIL PROTECTED]>: > > > hello, > > >

Re: Justifying text in a Tk label?

2002-11-26 Thread Kris Wolff
Than your pane is just centerd, and not the lable. Try to set the pane over the full size ( mybe with a frame ->pack(-side=>'top' -fill=>'x', -expand=>1); kris On 25.11.2002 17:50 Uhr, "Beckett Richard-qswi266" <[EMAIL PROTECTED]> wrote: > That doesn't seem to work, either. > > Thanks. > > R

RE: Justifying text in a Tk label?

2002-11-26 Thread Beckett Richard-qswi266
Aha! Thanks guys! This is what I was trying to do, the part with the shorter label... # use Tk; my $mw=tkinit; my $label=$mw->Label( -text=> 'This is a very long, long, long label.', -relief=>'groove'); $label->pack( -side=>'top', -fill=>'both', -expand=>'both'); my $label1=$

Re: Excel to html format

2002-11-26 Thread csaba . raduly
On 25/11/2002 21:13:28 perl-win32-users-admin wrote: >Hello, > >    I have an Excel spreadsheet that a person saves to a network drive >daily.  I want to automate the task of opening the file and saving it as html >(the person can't do it themselves, their not technical enough! ).  I know th

PPM problems with ActiveState 5.8.0

2002-11-26 Thread Philip Morley
I have installed ActiveState Perl 5.8.0 build 802 and have noticed the (Bshell prompt when you start PPM seems to be wrong. Instead of: (B (BPPM> (B (BI get: (B $B"+(B[4;mppm> $B"+(B[1m $B"+(B[0m$B"+(B[4;mppm> $B"+(B[1m (B (BAny ideas why? (B (BThanks, (B (BPhil Morley (B (

RE: PPM problems with ActiveState 5.8.0

2002-11-26 Thread Bellenger, Bruno \(Paris\)
These are ANSI escape codes. Make a search on Google on these keywords if it is not clear to you what they are. Why PPM is trying to make use of them is another question though. What is your platform ? _ Bruno Bellenger Sr. Network/Systems Adminis

RE: thread limit in fork?

2002-11-26 Thread Edwards, Mark \(CXO\)
I'm *really* confused now. I've read topic after topic on this list saying that fork doesn't work on Windows. I've tried some trivial examples and it work. Other's have written that it works in some case but not all. One note said that a program worked most of the time but occasionally gets all

Net-DNS for 5.8/802

2002-11-26 Thread Stovall, Adrian M.
Does anybody know where I can find a Net-DNS module built for ActivePerl build 802? I'm not in dire need, but it'd be nice. perl -e "sub Sub{return reverse(@_);}$i='ohce';$_='.$yyye k ca i Xl $yyye jX $yyyehto ZfX tq $uQ';s+[ \$]++g;s-j-P-;s^yyy^r^g;s:i:H:;s!X! !g;s|Z|n|;s*Q*J*;s{q}{s}g;s(f)(A);

Re: Substitution

2002-11-26 Thread Erich C. Beyrent
> Either quote the meta characters in the search string by enclosing it > in \Q \E sequences or quote each meta separtately by preceeding > it with a \ character, e.g. > > s!\Q$search\E!$replace!; > > or > > @search=split(//,$search); > foreach $char (@search) { > $char="\\$char" if $char=~/\W

Off Topic: SunOS Mailing List?

2002-11-26 Thread John Drabinowicz
Title: Off Topic: SunOS Mailing List? Does anyone out there know of a SunOS/Perl Mailing List? How would one join it? Thanks, John D.

RE: PPM problems with ActiveState 5.8.0

2002-11-26 Thread Philip Morley
|-+---> | | "Bellenger, Bruno (Paris)" | | | <[EMAIL PROTECTED]> | | | Sent by:| | | [EMAIL PROTECTED]| | | veStat

Re: Substitution

2002-11-26 Thread Lee Goddard
Er, what were you trying to do again? Why won't { my @bits = split":",$in; } be good enough to get the bits, and the rewriting as {print join":",@bits} ? Sorry, little history in my box lee Lee Goddard, BA(Hons), MSc(Sussex) http://www.LeeGoddard.com/ since 1997. Direcotr: Little Bits Ltd

Re: Excel to html format

2002-11-26 Thread shurst
> Hello, > I have an Excel spreadsheet that a person saves to a network > drive daily. I want to automate the task of opening the file and > saving it as html (the person can't do it themselves, their not > technical enough! ). I know the OLE modules can let you manipulate > the dat

RE: Excel to html format

2002-11-26 Thread Ricci, Mark
Thanks for all the options. I will be able to go with the simplest example of Win32::OLE. The only hitch was to automate the process you have to delete the existing html file and associated folder so you don't get prompted to overwrite the existing file. Thanks again, Mark -Original Mess

RE: Excel to html format

2002-11-26 Thread Thomas_M
I will second the motion for Spreadsheet::ParseExcel. I have been working with statistical tables lately and have built a set of modules that takes Excel files as input and outputs valid XHTML 1.0 tables that are ADA Section 508 compliant. Recent versions of Spreadsheet::ParseExcel have worked fla

Re: Excel to html format

2002-11-26 Thread Thomas R Wyant_III
[EMAIL PROTECTED] wrote: > The $expletive produced by Excel claiming to be HTML > is just awful (and Office 2000 is even worse) You got that right. When HTMLizing "Put the CD in the CD drive" with Word2K, we got "Put the CD in the CD drive." > If you do save from Excel, make sure you run the

RE: Excel to html format

2002-11-26 Thread Tillman, James
> But unfortunately I have no experience with OLE to OpenOffice. > > Tom Wyant Which brings up an interesting question that's been on my mind lately. I don't know, but I would bet that OO doesn't even have an OLE interface. Has anyone been able to do any automation at all using OO on either Win

Re: PPM problems with ActiveState 5.8.0

2002-11-26 Thread David Sparks
On Tue, 2002-11-26 at 03:57, Philip Morley wrote: > I have installed ActiveState Perl 5.8.0 build 802 and have noticed the > shell prompt when you start PPM seems to be wrong. Instead of: > > PPM> > > I get: > > ←[4;mppm> ←[1m > ←[0m←[4;mppm> ←[1m > > Any ideas why? I don't know what may be c

Opening multiple files in parallel

2002-11-26 Thread Cutts III, James H.
I am developing an application where I am importing data from 4 separate flat files. A single record spans across all four of the files. I would like to be able to open all 4 files in parallel to make it easier to process them at the same time. The code I would like to use is: # Ope