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 of my .vbs file as parameter.
vokeMethod"),
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
sisyph...@optusnet.com.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-us
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
I do more 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');
$sc
in32-users-boun...@listserv.activestate.com] 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
exce
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 &quo
On Fri, Nov 2, 2012 at 2:39 PM, Dave Horner 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
>
n...@listserv.activestate.com
>> [mailto:perl-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
>> Subje
;
> 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 any events to be fired either. Perhaps Jan can weigh in
>> since he seems to be around t
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
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
ay, 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 "karaoke" functionality on my TTS (text to speech)
> editor. Meaning that I want to highlight words the moment
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
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:
http://www.mail-archive.com/perl-
AM, Leo Susanto wrote:
> Try this:
> http://stackoverflow.com/questions/837754/call-routine-in-access-module-from-net
>
> On Wed, Jun 29, 2011 at 10:19 AM, John Harrington
> wrote:
> > Hi Leo,
> > Thanks for this.
> > I tried this script on one of the machines
rror:
> 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
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.Applicatio
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
econd 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, ca
e to add 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:
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',
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
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
O
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 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
erl-win32-users-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 wrote:
> I should have stated that I did fir
On 3 April 2010 22:21, Brzezinski, Paul J 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
> years and according
users-boun...@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
Paul J
Cc: 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
e: TaskScheduler 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
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, fi
@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
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 (Sch
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"
To: Jenda Krynicky
Copies to: perl-win32-users@listserv.activestate.com
> That looks like a utility t
al intranet.
>
>
>
> Note that both Microsoft Visual 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 Off
at 10:58 AM, Jenda Krynicky 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'
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
both Microsoft Visual 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
t; gripe at the
bottom. 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...)
$window->{status} = 'Hi from PerlScript!'; # works!
http://www.xav.com/perl/site/lib/Win
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 ear
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
t; Name: OpenView_OpenVMS
>>>> Name: OpenView_OpenVMS(itanium)
>>>> Name: OpenView_SNMP
>>>> Name: OpenView_Solaris
>>>> Name: OpenView_Tru64
>>>> Name: OpenView_Unknown
>>>> Name: OpenView_Windows2000
>>>> Name: O
t;> Name: OpenView_Linux
>>> Name: OpenView_NNM
>>> Name: OpenView_OpenVMS
>>> Name: OpenView_OpenVMS(itanium)
>>> Name: OpenView_SNMP
>>> Name: OpenView_Solaris
>>> Name: OpenView_Tru64
>>> Name: OpenView_Unknown
>>> Name: Ope
ame: OpenView_Solaris
>> Name: OpenView_Tru64
>> Name: OpenView_Unknown
>> Name: OpenView_Windows2000
>> Name: OpenView_WindowsNT
>> Name: OpenView_WindowsServer2003
>> Name: OpenView_WindowsServer2008
>> Name: OpenView_WindowsVista
>> Name: OpenView_Wi
w_WindowsVista
> Name: OpenView_WindowsXP
> Name: Root_Special
> Name: Root_Unix
> Name: Root_Windows
>
> And the Perl-Script with the modification < #!perl
> use strict;
> use warnings;
> use Win32::OLE qw(in with);
> use Win32::OLE::Variant;
> use Data::Dump
Okay - Just to sum up the whole thing.
The original VBScript <GetObject("winmgmts:root/HewlettPackard/OpenView/data") or die
"WMI connection failed.\n";
if (Win32::OLE-> LastError() != 0) {
print "Error calling GetObject: " . Win32::OLE->LastError()
veState.com
> Subject: Re: 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 =
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
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
t; Subject: RE: WIN32::OLE WMI Out params
>
> > 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->
> 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 somet
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 issu
; & objChildGroups & vbCrLF
>>
>> For Each objItem In arrNodes
>>WScript.Echo "Name: " & objItem.Name
>> Next
>>
>> ' VBScript End
>>
>> The problem is that I can't find out how to get the
t; objGetRoot.GetChildNodeGroups(arrNodes, True)
>
> WScript.Echo "Child Group Count: " & objChildGroups & vbCrLF
>
> For Each objItem In arrNodes
> WScript.Echo "Name: " & objItem.Name
> Next
>
> ' VBScript End
>
> The pr
me
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("winmgmts:root/HewlettPackard/OpenView/
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: http://listserv.ActiveState
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 opera
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
TextToDisplay =>
> $bugID,
>
>});
>
>
> I get:
>
>OLE Error Win32::OLE(0.1709) error 0x80070057: "The parameter is
> incorrect"
>
>
53b}"
<![CDATA[
sub SayHello {
my($param) = shift @_;
return reverse($param);
}
]]>
(NOTE - there is a error in the docs and the > for the registration open
tag has to be moved to AFTER the properties). Once I do this, register
the component and then try to
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
.
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 for a
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
day, 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:
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
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
rather than 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
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
Hello ,
I am using WIn32::OLE to Read contents of an Excel sheet.
There is no issues on reading, but the problem is that Excel file opens on the
screen, during the time the script processes the file.
I don't need this.
One solution was to make it not visible ($Excel->{'Visible
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 a
Jan Dubois wrote:
> 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), help
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")
it gets/sets a dual 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(
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:
";(objectClass=*);AdsPath, cn;subTree"
So remove the space before subTree and the semi-colon following it. If
th
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:
";(objectCategory=group);distinguishedName, cn,
sAMAccountName; subtree;"
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
On Wed, 13 Feb 2008, Michael Ellery wrote:
> 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 the
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,
M
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
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
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
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
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
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
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 wit
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
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 al
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 t
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
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? Is it
cc
Subject
RE: w
x27;t appear 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
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} = "D
I begin to debug?
I am 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.c
> 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. :)
>
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
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->G
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-
1 - 100 of 530 matches
Mail list logo