Re: Perl-Win32-Users Digest, Vol 10, Issue 6 (Out of office: )
I am out of the office through May 11, 2007. I will respond to email and voicemail when I return. If you need immediate assistance, please contact Janice Albert. Thank you, Steve CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication. ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Perl-Win32-Users Digest, Vol 8, Issue 21 (Out of office: )
I am out of the office through April 6, 2007. I will respond to email and voicemail when I return. If you need immediate assistance, please contact Janice Albert. Thank you, Steve CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication. ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Perl-Win32-Users Digest, Vol 6, Issue 10 (Out of office: )
I am out of the office through January 29, 2007. I will respond to email and voicemail when I return. If you need immediate assistance, please contact Janice Albert. Thank you, Steve CONFIDENTIALITY NOTICE: This communication with its contents may contain confidential and/or legally privileged information. It is solely for the use of the intended recipient(s). Unauthorized interception, review, use or disclosure is prohibited and may violate applicable laws including the Electronic Communications Privacy Act. If you are not the intended recipient, please contact the sender and destroy all copies of the communication. ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Perl-Win32-Users Digest, Vol 1, Issue 1798 (Out of office: )
Hi. I received your email. I am out of the office from Friday, August
25, 2006 through Friday, September 15, 2006. I will respond to emails
and voicemails when I return. If you need assistance before then, please
contact Janice Albert.
Thank you,
Steve
perl-win32-users 08/25/06 12: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. Re: [OLE] Excel - problem creating multiple charts
(Lyndon Rickards)
--
Message: 1
Date: Thu, 24 Aug 2006 20:25:16 -0400
From: Lyndon Rickards [EMAIL PROTECTED]
Subject: Re: [OLE] Excel - problem creating multiple charts
To: rob johnson [EMAIL PROTECTED]
Cc: perl-win32-users@listserv.activestate.com
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
rob johnson wrote:
Hi
I am having a difficult time getting Excel automation to work
correctly.specifically, i've become hung up on creating multiple
charts.
I am able to make a basic XY Scatter plot with the following code:
==
$Sheet-Range(A:A,D:D,K:K,R:R)-Select;
$Chart = $Book-Charts-Add;
$Chart-{ChartType} = xlXYScatter;
$Chart-{Name}=Temperature;
==
and it correctly charts D, K, and R column data (temperatures) versus
the A column data (time)
but if i want to make another (separate) chart plotting E, L, and S
column data (conductivity) versus the A column data (time), and i
follow the above code with a similar block:
==
$Sheet-Range(A:A,E:E,L:L,S:S)-Select;
$Chart = $Book-Charts-Add;
$Chart-{ChartType} = xlXYScatter;
$Chart-{Name}=Conductivity;
==
it fails, with the following error message
OLE exception from Microsoft Excel:
Unable to get the Select property of the Range class
Win32::OLE(0.1704) error 0x800a03ec
in METHOD/PROPERTYGET Select at hexconvert.pl line 322
(where line 322 is in the second block:
$Sheet-Range(A:A,E:E,L:L,S:S)-Select; )
Can someone point out where I'm going wrong?
Also, If I could just find a reference of Excel OLE properties and
methods I think I could hack my way through it. But I haven't been
able to find anything like that.
does anyone know if such a list exists?
thanks,
rob
I know I've faced this in the past after converting recorded macro
verbatim. I can't easily test a
solution based on your example because it is not 'complete and
working'... ;-) A couple of things
that might help:
A snippet of mine that sets a range as source for a chart:
$range = A25: . $endCol . 26;
$Excel-ActiveSheet-ChartObjects('Chart 1')-Activate();
$Excel-ActiveChart-SetSourceData({Source = $pSheet-Range($range),
PlotBy = 2});
As I recall, it is possible to skip the ...Activate line and reference
the ChartObjects(...) instead
of ActiveChart in the line following it.
The VBA editor itself has the Object Browser documentation built-in -
right-click in editor pane.
Often, pasting the error right into Google yields valuable pointers or
solutions.
Even though I use perl almost exclusively over VBA I have had excellent
method advice from contributors
over on microsoft.public.excel.misc.
HTH - Lynn.
--
___
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 1, Issue 1798
*
CONFIDENTIALITY NOTICE: This communication with its contents may contain
confidential and/or legally privileged information. It is solely for the
use of the intended recipient(s). Unauthorized interception, review, use
or disclosure is prohibited and may violate applicable laws including
the Electronic Communications Privacy Act. If you are not the intended
recipient, please contact the sender and destroy all copies of the
communication.
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: Perl-Win32-Users Digest, Vol 26, Issue 3 (Out of office)
Hi. I received your email. I am out of the office from Monday, March 6, 2006
through Friday, March 10, 2006. I will respond to emails and voicemails when I
return. If you need assistance before then, please contact Janice Albert.
Thank you,
Steve
perl-win32-users 03/03/06 12:05
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. Re: Win32::TaskScheduler: local host? ($Bill Luebkert)
--
Message: 1
Date: Thu, 02 Mar 2006 00:58:43 -0800
From: $Bill Luebkert [EMAIL PROTECTED]
Subject: Re: Win32::TaskScheduler: local host?
To: Perl-Win32-Users@listserv.ActiveState.com
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Allegakoen, Justin Devanandan wrote:
Can you not just feed it $ENV{'COMPUTERNAME'} ?
Or Win32::NodeName
The other thing I remember doing a while back when we were migrating
machines was copying everything in $ENV{'windir'}\Tasks and putting it
all in the new machine's Tasks folder. In your case you should be able
to create the tasks locally and move/copy them over to the destination
machine.
--
___
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 26, Issue 3
***
CONFIDENTIALITY NOTICE: This communication with its contents may contain
confidential and/or legally privileged information. It is solely for the
use of the intended recipient(s). Unauthorized interception, review, use
or disclosure is prohibited and may violate applicable laws including
the Electronic Communications Privacy Act. If you are not the intended
recipient, please contact the sender and destroy all copies of the
communication.
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
