I am recereation leave, then on a training course and then on more
recreation leave from 1st February 2007 to 27th Februrary 2007
inclusive. For all matters relating to population health information and
surveillance, please contact Jill Kaldor (email
[EMAIL PROTECTED] or phone 02 9391 9266 ) who is acting in my
stead. I can be contacted through February by mobile phone or email, but
please refer all except personal matters to Jill in the first instance.
For personal matters you can email me at [EMAIL PROTECTED]
Tim C
---
Dr Tim Churches
Medical epidemiologist
Centre for Epidemiology and Research
New South Wales Department of Health
North Sydney NSW 2059 AUSTRALIA
Ph. +61 2 9391 9193
Fax +61 2 9391 9232
Email: [EMAIL PROTECTED]
>>> perl-win32-users 02/02/07 07:00 >>>
Send Perl-Win32-Users mailing list submissions to
perl-win32-users@listserv.ActiveState.com
To subscribe or unsubscribe via the World Wide Web, visit
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
or, via email, send a message with subject or body 'help' to
[EMAIL PROTECTED]
You can reach the person managing the list at
[EMAIL PROTECTED]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Perl-Win32-Users digest..."
Today's Topics:
1. ANNOUNCE: Perl Dev Kit 7.0 Beta 2 available (Jan Dubois)
2. Problem with error "Can't call method "Select" on an
undefined value" in Win32::OLE Excel script (Glen Plantz)
3. Re: Problem with error "Can't call method "Select" on an
undefined value" in Win32::OLE Excel script (Jan Dubois)
----------------------------------------------------------------------
Message: 1
Date: Wed, 31 Jan 2007 16:13:41 -0800
From: Jan Dubois <[EMAIL PROTECTED]>
Subject: ANNOUNCE: Perl Dev Kit 7.0 Beta 2 available
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
macosx@perl.org
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-ascii
I'm happy to announce the release of the Perl Dev Kit 7.0 Beta 2.
http://www.activestate.com/products/perl_dev_kit/beta.plex
If you never heard of the Perl Dev Kit before:
ActiveState Perl Dev Kit (PDK) is a suite of tools for rapidly
developing and delivering Perl applications. It includes everything
you need to turn Perl programs into ready-to-run executables, debug
Perl scripts, generate code for sophisticated filters, convert
useful VBScript code to Perl, and create .NET and ActiveX
components, Windows services and system tray applications.
The PDK is commercial software. You will need to purchase a license
for PDK 7.0 to continue to use it after the beta period.
This release extends the beta expiration period to March 20th 2007.
There are only minimal functional changes relative to Beta 1.
The purpose of the Beta program is to receive feedback on new
features. If you decide to try out the PDK 7 beta then please also
subscribe to the PDK-beta mailing list to discuss the beta with both
ActiveState and other beta tester.
In addition you can always file bugs and enhancement requests at
http://bugs.ActiveState.com
Major changes since PDK 6 are:
* Coverage and Hotspot Analyzer
Analyze code coverage and hotspots in Perl programs and test
suites. Test different versions or revisions of a program and
compare them visually, or compare different test runs on the same
code.
* Mac OS X Support
PerlApp, Filter Builder and the new Coverage and Hotspot Analyzer
are now available for Mac OS X (Universal).
* 64-Bit Support
64-bit command line versions of PerlApp are available for Linux
(x86_64), Solaris (Sparc) and Windows (x64). 64-bit command line
versions of PerlCtrl, PerlSvc and PerlTray are also included in the
Windows builds.
* Improved 32-Bit Support
The GUI interface to PerlApp, Filter Builder, and the Coverage and
Hotspot Analyzer are available for Solaris 10 on Intel (x86) and AIX
5.x. The command line version of PerlApp is available for HP-UX on
Itanium.
* Visual Package Manager (VPM)
VPM has been superseded by the native PPM4 GUI included in
ActivePerl 819 and later.
This beta release can be installed side-by-side with the PDK 6 release
version as long as it's installed in a separate directory. The
installer does this by default.
Cheers,
-Jan
------------------------------
Message: 2
Date: Thu, 1 Feb 2007 10:22:55 -0800
From: "Glen Plantz" <[EMAIL PROTECTED]>
Subject: Problem with error "Can't call method "Select" on an
undefined value" in Win32::OLE Excel script
To: <perl-win32-users@listserv.ActiveState.com>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Hi Folks,
I'm having trouble with code that I've done hundreds of times before,
but which in this case is causing the error "Can't call method "Select"
on an undefined value".
Here is a snippet of code:
my $excel_app = Win32::OLE->new('Excel.Application')
or die "could not create excel app\n";
$excel_app->{'Visible'} = 1;
# " $Excel_CSAA_Test_Retrieve " is pointing to a file in
the current directory...
my $excel_Retrieve_Workbook =
$excel_app->Workbooks->Add( { Template => $Excel_CSAA_Test_Retrieve } )
or die "could not open $Excel_CSAA_Test_Retrieve\n";
my $Sheet1 = $excel_Retrieve_Workbook->Worksheets(1);
$Sheet1->Activate();
$excel_Retrieve_Workbook->ActiveSheet->Range("A4")->Select();
print "\nExiting for test\n";
exit;
# ***************************************************
I get the error " "Can't call method "Select" on an undefined value" on
the line:
$excel_Retrieve_Workbook->ActiveSheet->Range("A4")->Select();
# ****************************************************
I don't understand what I'm doing wrong. I've done things similar to
this many times.
Can anyone see any problems with the above code???
Thanks in advance for any help.
Glen Plantz
Mitchell International
San Diego, California
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://aspn.activestate.com/ASPN/Mail/Browse/Threaded/perl-win32-users/attachments/20070201/bca0b9cd/attachment-0001.html
------------------------------
Message: 3
Date: Thu, 01 Feb 2007 10:35:31 -0800
From: Jan Dubois <[EMAIL PROTECTED]>
Subject: Re: Problem with error "Can't call method "Select" on an
undefined value" in Win32::OLE Excel script
To: "Glen Plantz" <[EMAIL PROTECTED]>
Cc: perl-win32-users@listserv.ActiveState.com
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-ascii
On Thu, 1 Feb 2007 10:22:55 -0800, "Glen Plantz"
<[EMAIL PROTECTED]> wrote:
># ***************************************************
>
>I get the error " "Can't call method "Select" on an undefined value" on
>the line:
>
>
>$excel_Retrieve_Workbook->ActiveSheet->Range("A4")->Select();
>
># ****************************************************
>
>I don't understand what I'm doing wrong. I've done things similar to
>this many times.
This means that the call to the Range() method is failing. You should
run your program with t`perl -w myscript.pl` to get more informative
error messages from Win32::OLE whenever something goes wrong.
Cheers,
-Jan
------------------------------
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
End of Perl-Win32-Users Digest, Vol 7, Issue 1
**********************************************
______________________________________________________________________
This email has been scanned for the NSW Department of Health by the
MessageLabs Email Security System. The Department regularly monitors
emails and attachments to ensure compliance with its Electronic
Messaging Policy.
_____________________________________________________________________
______________________________________________________________________
This email has been scanned for the NSW Department of Health by the MessageLabs
Email Security System. The Department regularly monitors emails and attachments
to ensure compliance with its Electronic Messaging Policy.
_____________________________________________________________________
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
