ry to call method `Xyz()` in perl I get the
> following (runtime) exception:
>
>
>
> Can't locate public method Xyz() for System.__ComObject
>
>
>
> If, however, I do more or less the same thing in perl, it works. (In the
> following case, passing only the contents
PerlNET::null("System.Reflection.Binder"),
$obj,
"System.Object[]"->new());
Using this approach would mean rewriting the whole wrapped perl module. And
using this syntax..
Now I am wondering if I am losing both the advantages of the dynamic keyword
in .
From: Miriam Heinz
Sent: Friday, October 23, 2015 8:51 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: C#, Perl and COM objects (PerlNET / Win32::OLE)
> I would greatly appreciate any help - or advise on where to look further.
Hi Miriam,
This is a very inactive list, and you may w
.au
> To: miriam.he...@itk-austria.com; perl-win32-users@listserv.ActiveState.com
> Subject: Re: C#, Perl and COM objects (PerlNET / Win32::OLE)
> Date: Sat, 24 Oct 2015 00:56:19 +1100
>
> From: Miriam Heinz
> Sent: Friday, October 23, 2015 8:51 AM
> To: perl-win32-users@
or less the same thing in perl, it works. (In the
following case, passing only the contents of my .vbs file as parameter.)
I can even use the script control :
sub UseScriptControl {
my ($self, $text, $) = @_;
my $script = Win32::OLE->new('ScriptControl');
$script->{Language} = 'VB
] On Behalf Of
ketan patel
Sent: Tuesday, April 09, 2013 2:21 PM
To: perl-win32-users@listserv.ActiveState.com
Subject: Win32::OLE Module - Excel chart Generation Problem
Hello All,
I am running following simple script on perl64 to generate chart on
excel but I am getting following errors without
Hello All,
I am running following simple script on perl64 to generate chart on excel
but I am getting following errors without generating any chart.
It opens excel sheet, write data into sheet but no chart.
Win32::OLE(0.1709) error 0x80020003: Member not found
in PROPERTYPUT ChartType at C
On Fri, Nov 2, 2012 at 2:39 PM, Dave Horner d...@thehorners.com wrote:
Hello,
I found this address from the following:
http://vlsicad.ucsd.edu/Resources/SoftwareLinks/ActivePerl/Perl-Win32/perlwin32faq12.html
I am looking for guidance on how to use Win32::OLE qw(in) on multiple
platforms
-win32-users-boun...@listserv.activestate.com] On Behalf Of Jan
Dubois
Sent: Monday, March 19, 2012 3:45 PM
To: 'Howard Tanner'; 'haratron'
Cc: perl-win32-users@listserv.activestate.com
Subject: RE: Win32::OLE events callback not executed
On Mon, 19 Mar 2012, Howard Tanner wrote:
I couldn't get
Subject: RE: Win32::OLE events callback not executed
On Mon, 19 Mar 2012, Howard Tanner wrote:
I couldn't get any events to be fired either. Perhaps Jan can weigh in
since he seems to be around today.
Sorry, I don't know _why_ it isn't working, but I've seen others run into
the same problem
Hello,
I want to implement karaoke functionality on my TTS (text to speech)
editor. Meaning
that I want to highlight words the moment they are spoken by the TTS system.
I read that I need to watch for the onWord event.
I have the same problem with this person:
From: perl-win32-users-boun...@listserv.activestate.com
[mailto:perl-win32-users-boun...@listserv.activestate.com] On Behalf Of
haratron
Sent: Monday, March 19, 2012 11:21 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: Win32::OLE events callback not executed
Hello,
I want to implement
I couldn't get any events to be fired either. Perhaps Jan can weigh in since
he seems to be around today.
Here's my test code:
use strict;
use Win32::OLE qw(EVENTS);
my $vox = Win32::OLE-new ('SAPI.SpVoice')
|| die Unable to create SAPI object\n;
sub Event {
my ($Obj, $Event, @Args
On Mon, 19 Mar 2012, Howard Tanner wrote:
I couldn't get any events to be fired either. Perhaps Jan can weigh in since
he seems to be around today.
Sorry, I don't know _why_ it isn't working, but I've seen
others run into the same problem with SAPI. Unfortunately
I don't have time to play
this error:
Last OLE32 error: Win32::OLE(0.1709) error 0x800a9d9f in
METHOD/PROPERTYGET Run
Any suggestions?
So far I've tried automation on four separate machines:
All with Access 2007 12.0.6535.5005 SP2 MSO 12.0.6554.5001
OS bits Perl version Works?
XP 32 5.10.1 yes
XP 32
-routine-in-access-module-from-net
On Wed, Jun 29, 2011 at 10:19 AM, John Harrington bearti...@gmail.com
wrote:
Hi Leo,
Thanks for this.
I tried this script on one of the machines that wasn't working yesterday
and
received only this error:
Last OLE32 error: Win32::OLE(0.1709
I have a very simple script using Win32::OLE that works perfectly on my
machine but not on other people's machines and I can't figure out why.
The script is as follows:
use strict;
use warnings;
use Win32::OLE;
my $oAccess;
$oAccess = Win32::OLE-new('Access.Application') or die Unable to start
Thank, so Access 2007 is installed in all of the machine
Could you please run this and see if there is any error?
use strict;
use warnings;
use Win32::OLE;
my $oAccess;
eval {$oAccess = Win32::OLE-GetActiveObject(Access.Application)};
if ($@) {
die Access.Application is not installed\n
an int. I want to write a Perl script that runs
this function in my Access database and passes it values for these
parameters. What would that look like?
It's not clear to me from reading the Win32::OLE documentation at CPAN how
to do this. If this is not possible with Win32::OLE, can you tell
this
to the OLE.xs file. I've attached the patch file with my proof of
concept code.
As you see in my patch, I commented out the code, initializing OLE in
multi threading mode, to make the CoRegisterMessageFilter call succeed.
The way to tell Win32::OLE to use OleInitialize() is to call
Win32::OLE
Hello,
we use Perl and the Win32::OLE module to do some automatic drawing
modifications with AutoCAD. Several scripts have been created and they
work well with AutoCAD up to 2009.
Starting with AutoCAD 2010 it unfortunately gets nearly impossible to
get a stable communication between Perl
Hi Peter,
This is a translation of a script from technet that works:
use Win32::OLE;
use Win32::OLE::Const 'Microsoft Word';
#
http://www.microsoft.com/technet/scriptcenter/resources/officetips/may05
/tips0512.mspx
my $word = new Win32::OLE 'Word.Application','' or die Cannot start
Peter Buck wrote:
Does anyone have an example of a perl script acting on MS Word
documents using Win32::OLE and Selection.Find.Execute? I have read
the
Win32 man page but its examples for Excel and Access don't help. I
found a Powershell script that does what I want but can't translate
Peter,
OLE needs Variant values. Perl and the OLE modules will convert most of
these on he fly for you, but sometimes I find I have a need to convert
booleans explicitly.
my $false = Win32::OLE::Variant-new(VT_VARIANT, 0);
my $true = Win32::OLE::Variant-new(VT_VARIANT, 1);
Mark
On 9/12/2010
On Sun, 12 Sep 2010, Peter Buck wrote:
Does anyone have an example of a perl script acting on MS Word
documents using Win32::OLE and Selection.Find.Execute?
Actually, I do, and it is even part of the Win32::OLE module
distribution on CPAN. But since it is not being installed
with the actual
Does anyone have an example of a perl script acting on MS Word
documents using Win32::OLE and Selection.Find.Execute? I have read the
Win32 man page but its examples for Excel and Access don't help. I
found a Powershell script that does what I want but can't translate.
The parts I'm
-boun...@listserv.activestate.com] On Behalf Of
Justin Allegakoen
Sent: Saturday, April 03, 2010 8:52 PM
To: perl-win32-users@listserv.ActiveState.com
Subject: Re: TaskScheduler and Win32::OLE
On 3 April 2010 22:21, Brzezinski, Paul J paul.brzezin...@hp.com wrote:
I should have stated that I did first
http://search.cpan.org/~UNICOLET/Win32-TaskScheduler2.0.3/TaskScheduler.pm
http://taskscheduler.sourceforge.net/
El 02/04/2010 11:05 p.m., Brzezinski, Paul J escribió:
I'm trying to use Win32::OLE to access the TaskScheduler [on Win2K3].
I would like to get all the configured tasks, finding
and Win32::OLE
http://search.cpan.org/~UNICOLET/Win32-TaskScheduler2.0.3/TaskScheduler.pm
http://taskscheduler.sourceforge.net/
El 02/04/2010 11:05 p.m., Brzezinski, Paul J escribió:
I'm trying to use Win32::OLE to access the TaskScheduler [on Win2K3]. I would
like to get all the configured tasks
: perl-win32-users@listserv.activestate.com
Subject: RE: TaskScheduler and Win32::OLE
There is no OLE object to work with tasks created by the Scheduled Tasks Wizard
(the Win32_ScheduledJob object in WMI only works with tasks scheduled with AT).
You can, however, use the schtasks command to produce
...@listserv.activestate.com
[mailto:perl-win32-users-boun...@listserv.activestate.com] On Behalf Of
Brzezinski, Paul J
Sent: Saturday, April 03, 2010 10:55 AM
To: Howard Tanner
Cc: perl-win32-users@listserv.activestate.com
Subject: RE: TaskScheduler and Win32::OLE
Respectively, XML might be an option for Vista and above
On 3 April 2010 22:21, Brzezinski, Paul J paul.brzezin...@hp.com wrote:
I should have stated that I did first try to download this module – it’s
missing from the Activestate repository. So I downloaded the source and
attempted to compile and it’s _broken_. It hasn’t been updated in several
I'm trying to use Win32::OLE to access the TaskScheduler [on Win2K3]. I would
like to get all the configured tasks, finding any that contain a pattern in the
task name and then display all/any details I can about those tasks.
I'm using OleView.exe to look at the SCHEDULERLib (Scheduler 1.0
@listserv.activestate.com
Subject: TaskScheduler and Win32::OLE
I'm trying to use Win32::OLE to access the TaskScheduler [on Win2K3]. I
would like to get all the configured tasks, finding any that contain a
pattern in the task name and then display all/any details I can about those
tasks.
I'm using
Date sent: Thu, 17 Dec 2009 12:36:27 -0600
Subject:Re: How to simulate VB Casting for $perl_objects via
Win32::OLE?
From: w...@serensoft.com w...@serensoft.com
To: Jenda Krynicky je...@krynicky.cz
Copies to: perl-win32-users@listserv.activestate.com
That looks like
Subject:How to simulate VB Casting for $perl_objects via
Win32::OLE?
Short version: how can we simulate .NET/VB object-type CASTing, in
Win32::OLE Perl?
Long version:
We're building a bridge between a java-web-app and a .net-based-desktop app.
Perl is the glue language of choice
Krynicky je...@krynicky.cz wrote:
Subject:How to simulate VB Casting for $perl_objects via
Win32::OLE?
Short version: how can we simulate .NET/VB object-type CASTing, in
Win32::OLE Perl?
Long version:
We're building a bridge between a java-web-app and a .net-based-desktop
app
Studio and Microsoft Office come with
Object browsers themselves, so if you have either of them, it might be
easier to use those browsers instead (the Win32::OLE browser is basically a
re-implementation of the one from Office 97 in Perl and DHTML).
Cheers,
-Jan
*From:* trill...@gmail.com
Hi --
Short version: how can we simulate .NET/VB object-type CASTing, in
Win32::OLE Perl?
Long version:
We're building a bridge between a java-web-app and a .net-based-desktop app.
Perl is the glue language of choice, of course :)
Where we've got trouble is that the .net programmers tell us we
Win32::OLE uses late binding (the IDispatch interface, aka OLE Automation);
there is no such thing as casting to different objects
as there is only a single IDispatch interface per object. This is the same as
using Jscript or VBScript, but not VB or C++ which
normally use early binding
. Is there a start-condition of some sort? (And Initialize and script
ActiveX controls not marked as safe is set to Enable for the local
intranet zone...)
script language=PerlScript
$window-{status} = 'Hi from PerlScript!'; # works!
/script
http://www.xav.com/perl/site/lib/Win32/OLE/Browser
with Object
browsers themselves, so if you have either of them, it
might be easier to use those browsers instead (the Win32::OLE browser is
basically a re-implementation of the one from Office 97 in
Perl and DHTML).
Cheers,
-Jan
From: trill...@gmail.com [mailto:trill...@gmail.com] On Behalf Of
w
strict;
use warnings;
use Win32::OLE qw(in with);
use Win32::OLE::Variant;
use Data::Dumper;
my $objWMIService =
Win32::OLE-GetObject(winmgmts:root/HewlettPackard/OpenView/data) or
die
WMI connection failed.\n;
if (Win32::OLE- LastError() != 0) {
print Error calling GetObject: . Win32
: Root_Unix
Name: Root_Windows
And the Perl-Script with the modification EOF;
#!perl
use strict;
use warnings;
use Win32::OLE qw(in with);
use Win32::OLE::Variant;
use Data::Dumper;
my $objWMIService =
Win32::OLE-GetObject(winmgmts:root/HewlettPackard/OpenView/data) or
die
WMI connection
Below...
-Original Message-
From: perl-win32-users-boun...@listserv.activestate.com
[mailto:perl-win32-users-boun...@listserv.activestate.com] On
Behalf Of Michael
Sent: Thursday, December 03, 2009 6:45 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE WMI
Hi Steven,
Well I tried your suggestion and I think that the Win32::OLE::Variant
module might be the solution, as I have found some other examples where WMI
[out] and variants are used.
http://www.infoqu.com/dev/perl-programming/using-perl-with-wmi-to-set-folder-level-permissions-16930-1/
http
I haven't followed your thread closely, but it seems like the relevant
bits from your first link are these:
my $objSecDescriptor = Win32::OLE::Variant- new (VT_DISPATCH|VT_BYREF);
my $retval =
$objDirectorySecSetting-GetSecurityDescriptor($objSecDescriptor);
..which seems to be filling
: WIN32::OLE WMI Out params
I haven't followed your thread closely, but it seems like the
relevant bits from your first link are these:
my $objSecDescriptor = Win32::OLE::Variant- new
(VT_DISPATCH|VT_BYREF); my $retval =
$objDirectorySecSetting-GetSecurityDescriptor($objSecDescriptor
: OpenView_WindowsVista
Name: OpenView_WindowsXP
Name: Root_Special
Name: Root_Unix
Name: Root_Windows
And the Perl-Script with the modification EOF;
#!perl
use strict;
use warnings;
use Win32::OLE qw(in with);
use Win32::OLE::Variant;
use Data::Dumper;
my $objWMIService =
Win32::OLE-GetObject(winmgmts:root
Name: OpenView_WindowsServer2008
Name: OpenView_WindowsVista
Name: OpenView_WindowsXP
Name: Root_Special
Name: Root_Unix
Name: Root_Windows
And the Perl-Script with the modification EOF;
#!perl
use strict;
use warnings;
use Win32::OLE qw(in with);
use Win32::OLE::Variant;
use Data
the array (@arrNodes) in
Perl.
# PerlScript Begin
use strict;
use warnings;
use Win32::OLE qw(in with);
use Data::Dumper;
my $objWMIService =
Win32::OLE-GetObject(winmgmts:root/HewlettPackard/OpenView/data) or die
WMI connection failed.\n;
my $objOV_NodeGroup = $objWMIService-Get(OV_NodeGroup);
my
' VBScript End
The problem is that I can't find out how to get the array (@arrNodes)
in Perl.
# PerlScript Begin
use strict;
use warnings;
use Win32::OLE qw(in with);
use Data::Dumper;
my $objWMIService =
Win32::OLE-GetObject(winmgmts:root/HewlettPackard/OpenView/data)
or die WMI connection
WScript.Echo Name: objItem.Name
Next
' VBScript End
The problem is that I can't find out how to get the array (@arrNodes)
in Perl.
# PerlScript Begin
use strict;
use warnings;
use Win32::OLE qw(in with);
use Data::Dumper;
my $objWMIService =
Win32::OLE-GetObject
When troubleshooting OLE issues, it is best to have the following code
after each OLE command...
If (Win32::OLE-LastError() != 0) {
print error calling blah: . Win32::OLE-LastError() . \n;
exit 0;
}
...Or something similar, so you can see what OLE had issues with (if
anything). It might
When troubleshooting OLE issues, it is best to have the following code
after each OLE command...
If (Win32::OLE- LastError() != 0) {
print error calling blah: . Win32::OLE- LastError() . \n;
exit 0;
}
...Or something similar, so you can see what OLE had issues with (if
anything
Hi List,
I am opening word document through Win32::OLE and saving as Plain Text with
Encoding option MS-DOS and Insert-Line-Break option.
I achieved the above output through perl, but output not matching with the
output which is done the same manual operation in MS-word.
Complete code
Hi.
Ramkumar wrote:
I am opening word document through Win32::OLE and saving as Plain Text with
Encoding option MS-DOS and Insert-Line-Break option.
I achieved the above output through perl, but output not matching with the
output which is done the same manual operation in MS-word
Hi Todd Beverly,
Thanks for your excellent answer. I got expected output. Once again I like
to say many thanks.
Regards,
Ramkumar,
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe:
-Cells($row,
$col),
Address =
http://nvbugs/$bugID;,
TextToDisplay =
$bugID,
});
I get:
OLE Error Win32::OLE(0.1709) error 0x80070057
this, register
the component and then try to run the following script:
use strict;
use warnings;
use Win32::OLE;
Win32::OLE-Option(Warn = 3);
my $r = new Win32::OLE('Easy.WSC');
print hello, world\n;
...I still get a crash. Has anyone else had luck instantiating WSCs with
Win32::OLE in perl 5.10
to do with my actual skript but my REGISTRY
still had the entries refering to that no more existing drive under the
pathes
HKEY_CLASSES_ROOT\TypeLib\...
HKEY_LOCAL_MACHINE\TypeLib\
So when using Win32::OLE::Const in my skript, perl tried to find the
drive which did not exist
Hi,
I have a real big perl program
- it runs already for a couple of years and I am always adding some
features.
So since a few days it needs over 2 Minutes to start!!!
I did a profiling and the problem seems to be the
Win32::OLE::Const:::_Typelib
So here is the actual output of the profiler
.
Cheers,
-Jan
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: September 5, 2008 2:56 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: perl starts very slow using WIN32::OLE
Hi,
I have a real big perl program
- it runs already
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Howard
(PFE)
Sent: Friday, 15. August 2008 1:34 AM
To: Neson Maxmelbin (RBEI/EMT4); perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE help
I'll type this directly in so I might make a typo
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Neson Maxmelbin (RBEI/EMT4)
Sent: 18 August 2008 09:40
To: Steve Howard (PFE); perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE help
Hello Steve,
It does work and my machine shows the same values for minimise
, 18. August 2008 2:40 PM
To: perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE help
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Neson Maxmelbin (RBEI/EMT4)
Sent: 18 August 2008 09:40
To: Steve Howard (PFE); perl-win32-users@listserv.ActiveState.com
Subject: RE
Hello,
if you just want to read data from an Excel file, you might consider the
Spreadsheet::ParseExcel module. I would think that using the OLE module
always starts an Excel instance (visible or not) whereas the Spreadsheet
module operates directly on the XLS file.
Ekkehard
the
literal values.
See if this helps.
Steve
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neson Maxmelbin
(RBEI/EMT4)
Sent: Thursday, August 14, 2008 4:30 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: WIN32::OLE help
Hello ,
I am using WIn32::OLE to Read contents
G'Day,
I think I've uncovered a bug as I'm getting the following error message
when attempting to call the EnumValues method of the StdRegProv WMI
class:
Faulting application perl.exe, version 5.10.0.1002, faulting module
perl510.dll, version 5.10.0.1002, fault address 0x00074d42.
I'm
interface object that is implemented in
a different COM component.
Using Win32::OLE, it doesn't let me do a normal property assignment --
i.e. this fails:
$myObj-{TestSuite} = $someOtherObj;
..however, it DOES let me do by ref assigment:
$myObj-LetProperty('TestSuite', $someOtherObj);
Can someone
On Wed, 28 May 2008, Michael Ellery wrote:
I have a COM component with a property defined like this (IDL):
[propput, id(30), helpstring(property TestSuite)] HRESULT
TestSuite([in] IUnknown *pVal);
Try adding a second line here:
[propputref, id(30), helpstring(property TestSuite)]
Using Win32::OLE to create an ADO object and then query Active Directory
using an LDAP query the last field returned contains the additional text
of ;Subtree; in the fields name.
My query string:
LDAP://OU=Business_Functions,OU=Global
Groups,DC=xxx,DC=com;(objectCategory=group);distinguishedName
Removing the trailing semi-colon did the trick.
From: Howard Tanner [mailto:[EMAIL PROTECTED]
It's been a while, so I looked it up. From MS:
LDAP://DC=Fabrikam,DC=com;(objectClass=*);AdsPath, cn;subTree
So remove the space before subTree and the
Hi,
It seems what when using perl Win32::OLE for WMI queries it produces
different results depending on method used to connect to server,
examples bellow, can somebody explain this issue?
Examples
Using ConnectServer() I get
ActiveSessions: 0
TotalSessions: 0
Script
#!/usr/bin/perl
use
Can Win32::OLE access methods/props marked as hidden in the IDL? There
happens to be one property we have marked as such and I tried the naive
thing:
my $secret = $object-HiddenProperty
...and it was rejected. Is there some way to ask Win32::OLE to ignore
the hidden attribute?
TIA,
Mike
h for some reason, i thought that use Win32::OLE::Variant did
stringify Win32::OLE::Variant objects. my understanding now is that it
just makes these display correctly if they are dates.
i am a newbie to Win32::OLE::Variant.
could you point me towards some example code that shows how
On Thu, 07 Feb 2008, Kevin Beverly wrote:
h for some reason, i thought that use Win32::OLE::Variant
did stringify Win32::OLE::Variant objects. my understanding now is
that it just makes these display correctly if they are dates.
i am a newbie to Win32::OLE::Variant.
could you point
Given some object and a property:
my $obj = new Win32::OLE(SOME.class);
my $val = $obj-{SomeProperty};
...is there some way to determine the VT type of $val (or of
SomeProperty, equivalently). I often run into strange problems where I
expect a 32 bit negative value from some property, but when
Jan Dubois wrote:
On Mon, 04 Feb 2008, Michael Ellery wrote:
Given some object and a property:
my $obj = new Win32::OLE(SOME.class);
my $val = $obj-{SomeProperty};
...is there some way to determine the VT type of $val (or of
SomeProperty, equivalently). I often run into strange problems
On Mon, 04 Feb 2008, Michael Ellery wrote:
Given some object and a property:
my $obj = new Win32::OLE(SOME.class);
my $val = $obj-{SomeProperty};
...is there some way to determine the VT type of $val (or of
SomeProperty, equivalently). I often run into strange problems where I
expect a 32
hi,
i have an active state perl program that parses ms excel files for
loading into postgresql.
i use
use Win32::OLE::Const 'Microsoft Excel';
use Win32::OLE::Variant;
to get the dates as text from a spreadsheet. i store the data as an
array of hashes and write it to disk with storable
On Fri, 01 Feb 2008, Kevin Beverly wrote:
i have an active state perl program that parses ms excel files for
loading into postgresql.
i use
use Win32::OLE::Const 'Microsoft Excel';
use Win32::OLE::Variant;
to get the dates as text from a spreadsheet. i store the data as an
array
Hello,
Problem Description
I am experiencing erratic problems with a Perl script as of late. When
attempting to instantiate a Win32::OLE object (CDO.Message) near the end of
the script (5,000 lines), the script simply ends without any error. The
%ERRORLEVEL% at that point has
just running some quick COM code in perl and I notice this: if I call a
property or method that returns VT_I4, Win32::OLE maps that to a perl
integer in scalar context. When I call a property or method that
returns VT_INT, however, it gets mapped to a perl string. Is this
deliberate
On Wed, 09 Jan 2008, Michael Ellery wrote:
just running some quick COM code in perl and I notice this: if I call
a property or method that returns VT_I4, Win32::OLE maps that to a
perl integer in scalar context. When I call a property or method that
returns VT_INT, however, it gets mapped
Jan Dubois wrote:
On Wed, 09 Jan 2008, Michael Ellery wrote:
just running some quick COM code in perl and I notice this: if I call
a property or method that returns VT_I4, Win32::OLE maps that to a
perl integer in scalar context. When I call a property or method that
returns VT_INT, however
On Wed, 09 Jan 2008, Michael Ellery wrote:
The VT_TYPE coming into my put_Some_VARIANT_Property was actually
VT_BSTR in this case, which I was not expecting. Simply wrapping int()
around the get call works fine, but a fix to Win32::OLE would be great.
I think I'll also update my VARIANT
worksheet is created
and named:
#--create and open the first worksheet
my $excel = Win32::OLE-new(Excel.Application);
$excel-{Visible} = 1;
my $book = $excel-Workbooks-Add;
my $sheet = $book-Worksheets(1);
$sheet-{Name} = Daily Message Volume By Queue Manager;
**cells
Subject
RE: win32::ole (excel) question
to do so.
Cheers,
-Jan
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: August 10, 2007 10:30 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: win32::ole (excel) question
Hi all,
Weird situation with creating new worksheets and keeping
using:
Windows XP, Perl 5.8.8 Build 5.17, and the most recent version of
libwin/Win32::OLE downloaded using ppm3 from ActiveState.
Thanks in Advance,
Chris
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http
The following code has the benefit of using NT credentials of the
currently logged in user. But, the currently logged in user needs to
have access in Exchange. :)
No passwords in clear text to glean from your scripts That's
usually a good thing. :)
$OLECon =
Win32::OLE-GetObject
I use this to query Exchange Mailbox and Public Folder sizes locally on
the server:
use Win32::OLE qw(in);
# Get item counts and sizes for each mailbox on the target server
#
my $OLECon=
Win32::OLE-GetObject('winmgmts:localhost\\root\\MicrosoftExchangeV2')
or die WMI Connection Failed\n;
my
Figured it out:
$host = 192.168.42.3;
$user = vdom\\Administrator;
$pass = password;
$WMI = Win32::OLE-new('WbemScripting.SWbemLocator') ||
die Cannot access WMI on local machine: , Win32::OLE-LastError;
$OLECon = $WMI-ConnectServer($host, root\\MicrosoftExchangeV2, $user,
$pass
The following code has the benefit of using NT credentials of the
currently logged in user. But, the currently logged in user needs to
have access in Exchange. :)
No passwords in clear text to glean from your scripts That's
usually a good thing. :)
$OLECon =
Win32::OLE-GetObject
Thanks for sharing your work on Exhange (Win32::Exchange) with the
community Steven.
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Hi,
I am attempting to transfer data from a word table to Excel using
Win32::OLE. I am able to do it with the following piece of code, but I am
getting two little boxes after the text in each of the Excel cells. I
presume these are Word formatting characters. How can I filter these out? I
am
PROTECTED] On Behalf Of
jagdish eashwar
Sent: May 11, 2007 6:13 PM
To: perl-win32-users@listserv.activestate.com
Subject: Win32::OLE - filtering out ms word formatting characters
Hi,
I am attempting to transfer data from a word table to Excel using Win32::OLE. I
am able to do
When Win32::OLE uses CP_UTF8, then it will convert the UCS2 as returned from
COM (the BSTR datatype) into UTF-8. There should be no
loss of information in this step, as everything in UCS2 can also be represented
in UTF8. The conversion is done by a Windows API
and not by Perl internals
Thanks Jan - that's very clear and exactly what I needed to know.
I've got most of my conversions working - but there are a few
exceptions and I think your explanation has given me enough information
to track then down and handle them.
(I'm not using the Win32::OLE UTF8 forcing - and am
1 - 100 of 468 matches
Mail list logo