Perl/OLE/Excel Sort Syntax

2000-12-12 Thread John Garrett
Does anyone know the correct syntax for sorting a range in a EXCEL 97 worksheet? John Garrett ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users

Re: Little Help with Associate Arrays

2000-12-12 Thread Carl Jolley
On Tue, 12 Dec 2000 [EMAIL PROTECTED] wrote: > What is wrong with the following: > > @Customer[11] = "Citizen Bank"; > @Cust_DID[33] = "1230"; > $cust_did{@Cust_DID[11]} = @Customer[33]; > $did = "1230"; > $cust_name = ($cust_did{$did}); > print "Customer name = $cust_name.\n"; > exit; You are

Re: negation

2000-12-12 Thread Carl Jolley
On Mon, 11 Dec 2000, $Bill Luebkert wrote: > Doug Brewer wrote: > > > > sorry for this simple question. I can't quite get the hang of negation in perl. > > > > for instance, this doesn't work: > > > > if (!($$links{$name} =~ m/http:/)) { > > code goes here > > } > > > > if

RE: how to set PERL5LIB?

2000-12-12 Thread Carl Jolley
On Mon, 11 Dec 2000, Frank Merrow wrote: > At 04:04 PM 12/11/00, Dunnigan,Jack [Edm] wrote: > >-Original Message- > >From: Jimmy S. Lim [mailto:[EMAIL PROTECTED]] > >Sent: Monday, December 11, 2000 4:46 PM > > > > >but how do i set the PERL5LIB environment? > > > >In a MSDOS window or you

Re: negation

2000-12-12 Thread Carl Jolley
On Mon, 11 Dec 2000, Doug Brewer wrote: > sorry for this simple question. I can't quite get the hang of negation in perl. > > for instance, this doesn't work: > > if (!($$links{$name} =~ m/http:/)) { > code goes here > } > > if a link is absolute, I want to ignore it. If it i

Kill a hung instance of MS Word

2000-12-12 Thread Rafala, Michael
I'm using Win32::OLE to open files in MS Word. Occasionally Word encounters a corrupt file that it cannot open, and so Word just hangs. The Perl script making the OLE calls also hangs while it waits for Word to open the file. I need to unhang Word by killing it. My current plan (unless there's so

Re: how to set PERL5LIB?

2000-12-12 Thread Carl Jolley
On Tue, 12 Dec 2000, Jimmy S. Lim wrote: > hi perl friends, > > i'm reading a book which instructs : 'just set the PERL5LIB environment > variable so point to a directory you wihs ito be in the include search path > of the @INC. > forgive me for the stupid question, but how do i set the PERL5LIB

Re: how to sort a datafile

2000-12-12 Thread Carl Jolley
On Mon, 11 Dec 2000, $Bill Luebkert wrote: > [EMAIL PROTECTED] wrote: > > > > sort function of perl is said to sort arrays. > > > > i have created a plain text file, having 2500 records separated by > > cr-lf, each record having five fields, each one put within a { and }% > > > > how to sort t

Re: Little Help with Associate Arrays

2000-12-12 Thread $Bill Luebkert
[EMAIL PROTECTED] wrote: > > What is wrong with the following: > > @Customer[11] = "Citizen Bank"; > @Cust_DID[33] = "1230"; > $cust_did{@Cust_DID[11]} = @Customer[33]; Swap your 11 and 33. > $did = "1230"; > $cust_name = ($cust_did{$did}); > print "Customer name = $cust_name.\n"; > exit; --

Little Help with Associate Arrays

2000-12-12 Thread bb
What is wrong with the following: @Customer[11] = "Citizen Bank"; @Cust_DID[33] = "1230"; $cust_did{@Cust_DID[11]} = @Customer[33]; $did = "1230"; $cust_name = ($cust_did{$did}); print "Customer name = $cust_name.\n"; exit; ___ Perl-Win32-Users mailing

Re: printer device control

2000-12-12 Thread Philip Newton
john z wrote: > what are the preferred methods for controlling output to a > printer with perl. for example, if you wanted to print a > string 'hello' at a position of 1.5 inches down and 2 inches > right, what could you do. Read your printer's manual and output the correct escape sequences to t

Re: Newbie Questions

2000-12-12 Thread Cassell . David
Aldo said: > also Dave Roth's books deserve a mention . . . . . > they're the most excellent Win32-specific Perl resource around Agreed. How could I have forgotten a guy named Dave? :-) David -- David Cassell, OAO Corp. [EMAIL PROTECTED] Senior computing specialist

Re: Newbie Questions

2000-12-12 Thread Aldo Calpini
[EMAIL PROTECTED] wrote: >> Are the O'Reily ones the best, or should I look at >> something else? > O'Reilly with two ells. > [...] also Dave Roth's books deserve a mention: - Win32 Perl Programming: The Standard Extensions (Macmillan Technical Publishing) ISBN: 1578700671 - Win32 Perl Scri

Re: Newbie Questions

2000-12-12 Thread Cassell . David
Bill wrote [in part]: > Can anyone reccomend a book or books for learning Perl for Windows? Depending on your background, I'd recommend either: Learning Perl on win32 Systems [Schwartz, Olson, & Christiansen] [published by O'Reilly, ora.com] or Elements of Programming with Perl [Andrew John

Re: how can I even begin to access some WIN32 specific API's

2000-12-12 Thread Aldo Calpini
Christopher Sagayam wrote: > This is the code > > [...] > > Now can anyone give me some pointers as to how can I even > begin using the code above or incorporate it in my perl > scripts? > > should I use WIN32::API or something like that ? yes, you can use Win32::API for this. I've also started

RE: Newbie Questions

2000-12-12 Thread Rivera, Claudia
I think the O'Reilly books are an excellent source for learning Perl. I also like Perl in 21 days. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 12, 2000 7:08 AM To: Bill Wonch Cc: [EMAIL PROTECTED] Subject: Re: Newbie Questions I persona

RE: how to set PERL5LIB?

2000-12-12 Thread Cornish, Merrill
>>> or should it be: SET PERL6.2LIB No, it would still be PERL5LIB. The '5' refers to the version of Perl (Perl 5 versus, say, Perl 4) rather than to the build number. Perl 6 is still in the indefinite future. Merrill > -Original Message- > From: Jimmy S. Lim [SMTP:[EMAIL PROTECTED]] >

Re: how to set PERL5LIB?

2000-12-12 Thread Jimmy S. Lim
thanks jack, frank & zoltan! is it also SET PERL5LIB for Activestate Build 6.20? or should it be: SET PERL6.2LIB=C:\PATH\TO\PERL\LIB i just want to understand the principle... jim - Original Message - From: Frank Merrow <[EMAIL PROTECTED]> To: Dunnigan,Jack [Edm] <[EMAIL PROTECTED]> Cc:

Re: Newbie Questions

2000-12-12 Thread SCOTT_SISSON
I personally like the O'Reilly books myself. I have the Perl CD book shelf (6 books on a CD) which I reference frequently. Also, learning about regular expressions will be very useful. I am also reading Mastering Regular Expressions by Jeffrey Friedl (also through O'Reilly) which I find very u