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 value of

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

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

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 the

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 (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

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

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!

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/; }

RE: PPM problems with ActiveState 5.8.0

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

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 data in

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

Re: Excel to html format

2002-11-26 Thread Thomas R Wyant_III
[EMAIL PROTECTED] wrote: snip! 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 addressCD drive/address. If you do save from Excel, make

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 Win32

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 causing this

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: #