RE: Win32::OLE Module - Excel chart Generation Problem

2013-04-17 Thread Steven Manross
While I don't have your exact setup, this script works fine in perl 5.8 (32-bit), Excel 2003 (32-bit) on Win Server 2003 (32-bit).. Yes, it's a dated config.. But it's running fine for now. As well, I ran this on Win7 (x64), Perl 5.8 (32-bit), Excel 2010 (32-bit). it worked fine again. (Which

Re: Win32::OLE events callback not executed

2012-04-12 Thread haratron
-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

Re: Win32::OLE events callback not executed

2012-03-24 Thread haratron
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

RE: Win32::OLE events callback not executed

2012-03-19 Thread Howard Tanner
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

RE: Win32::OLE events callback not executed

2012-03-19 Thread Howard Tanner
-users-boun...@listserv.activestate.com [mailto:perl-win32-users-boun...@listserv.activestate.com] On Behalf Of haratron Sent: Monday, March 19, 2012 1:54 PM To: Howard Tanner Cc: perl-win32-users@listserv.activestate.com Subject: Re: Win32::OLE events callback not executed Thanks for the answer. I've

RE: Win32::OLE events callback not executed

2012-03-19 Thread Jan Dubois
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

Re: Win32::OLE

2011-06-29 Thread Leo Susanto
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 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

Re: Win32::OLE

2011-06-29 Thread John Harrington
Hi Leo, Yes, it turns out the security setting is the issue. On machines where this didn't work, the security settings were different than on the machines where it did work. Thank you very much for your help with this puzzling issue. It is very much appreciated. For any other users who may

Re: Win32::OLE

2011-06-28 Thread Leo Susanto
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;

RE: Win32::OLE on MS Word using Selection.Find.Execute

2010-09-13 Thread Brian Raven
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

Re: Win32::OLE on MS Word using Selection.Find.Execute

2010-09-13 Thread Mark Leighton
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

RE: Win32::OLE on MS Word using Selection.Find.Execute

2010-09-13 Thread Jan Dubois
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

Re: WIN32::OLE WMI Out params

2009-12-05 Thread Michael
On Fri, 04 Dec 2009 17:10:26 -0800, Michael Ellery mi...@s2technologies.com wrote: Michael wrote: Okay - Just to sum up the whole thing. The original VBScript EOF; Option Explicit Dim objWMIService, objOV_NodeGroup, objGetRoot, objChildGroups, arrNodes, objItem Set objWMIService =

Re: WIN32::OLE WMI Out params

2009-12-05 Thread Michael
On Sat, 05 Dec 2009 05:58:48 -0800, Michael Ellery mi...@s2technologies.com wrote: Michael wrote: On Fri, 04 Dec 2009 17:10:26 -0800, Michael Ellery mi...@s2technologies.com wrote: Michael wrote: Okay - Just to sum up the whole thing. The original VBScript EOF; Option Explicit Dim

RE: WIN32::OLE WMI Out params

2009-12-04 Thread Steven Manross
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

RE: WIN32::OLE WMI Out params

2009-12-04 Thread Michael
: 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 Out params When troubleshooting OLE issues

Re: WIN32::OLE WMI Out params

2009-12-04 Thread Michael Ellery
...@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 Out params When troubleshooting OLE issues, it is best to have the following code after each OLE command... If (Win32::OLE

RE: WIN32::OLE WMI Out params

2009-12-04 Thread Steven Manross
-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 Out params When troubleshooting OLE issues

RE: WIN32::OLE WMI Out params

2009-12-04 Thread Michael
Okay - Just to sum up the whole thing. The original VBScript EOF; Option Explicit Dim objWMIService, objOV_NodeGroup, objGetRoot, objChildGroups, arrNodes, objItem Set objWMIService = GetObject(winmgmts:root\HewlettPackard\OpenView\data) Set objOV_NodeGroup = objWMIService.Get(OV_NodeGroup)

Re: WIN32::OLE WMI Out params

2009-12-04 Thread Michael Ellery
Michael wrote: Okay - Just to sum up the whole thing. The original VBScript EOF; Option Explicit Dim objWMIService, objOV_NodeGroup, objGetRoot, objChildGroups, arrNodes, objItem Set objWMIService = GetObject(winmgmts:root\HewlettPackard\OpenView\data) Set objOV_NodeGroup =

RE: WIN32::OLE WMI Out params

2009-12-03 Thread Brian Raven
Michael wrote: Hi, I'm a novice regarding Perl, and need some help converting a VBScript to a PerlScript. The following VBScript returns some data from HP OpenView. The GetChildNodeGroups method returns the number of ChildGroups, and the [out] parameter NodeGroups returns an array

RE: WIN32::OLE WMI Out params

2009-12-03 Thread Michael
Michael wrote: Hi, I'm a novice regarding Perl, and need some help converting a VBScript to a PerlScript. The following VBScript returns some data from HP OpenView. The GetChildNodeGroups method returns the number of ChildGroups, and the [out] parameter NodeGroups returns

RE: WIN32::OLE WMI Out params

2009-12-03 Thread Steven Manross
@listserv.ActiveState.com Subject: RE: WIN32::OLE WMI Out params Michael wrote: Hi, I'm a novice regarding Perl, and need some help converting a VBScript to a PerlScript. The following VBScript returns some data from HP OpenView. The GetChildNodeGroups method returns the number

RE: WIN32::OLE WMI Out params

2009-12-03 Thread Michael
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).

RE: WIN32::OLE help

2008-08-18 Thread Neson Maxmelbin (RBEI/EMT4)
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

RE: WIN32::OLE help

2008-08-18 Thread Brian Raven
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

Re: WIN32::OLE help

2008-08-14 Thread ekkehard . goerlach
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

RE: WIN32::OLE help

2008-08-14 Thread Steve Howard (PFE)
I'll type this directly in so I might make a typo. You should be able to set the state in the application object: $Excel-{WindowState} = -4140; To set back to normal mode: $Excel-{WindowState} = -4143; The way to find this is to record a macro in Excel, and do what you want to see. Then view

RE: Win32::OLE -- assignment to property of type IUnknown..how?

2008-05-28 Thread Jan Dubois
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)]

RE: Win32::OLE problem

2008-05-13 Thread Bullock, Howard A.
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

RE: Win32::OLE and VT_INT

2008-01-09 Thread Jan Dubois
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 to a

Re: Win32::OLE and VT_INT

2008-01-09 Thread Michael Ellery
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,

RE: Win32::OLE and VT_INT

2008-01-09 Thread Jan Dubois
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

RE: win32::ole (excel) question

2007-08-10 Thread dkazatsky
Subject RE: win32::ole (excel) question

RE: win32::ole (excel) question

2007-08-10 Thread Jan Dubois
The first sheet name is never changed from Sheet1 to begin with because you are trying to set it to a name with 37 characters. The maximum sheet name length in Excel is 31 characters. It would be nice if Excel returned an error if you try to assign an invalid name, but it doesn't appear to

RE: Win32::OLE - filtering out ms word formatting characters

2007-05-11 Thread Jan Dubois
I guess these will just be CR/NL characters. You should be able to strip them in Perl, e.g. with $wordcell = $tbl-Cell($row,$col)-Range-{Text}; $wordcell =~ s/[\x00-\x1f]//g; $sheet-Cells($row,$col)-{Value} = $wordcell; Cheers, -Jan From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Win32::OLE - ? encoding of returned strings

2007-05-01 Thread Jan Dubois
with Windows code pages better. Cheers, -Jan From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Trotman Sent: April 29, 2007 2:36 PM To: perl-win32-users@listserv.ActiveState.com Subject: Re: Win32::OLE - ? encoding of returned strings Thanks - that's very useful. And I had

Re: Win32::OLE - ? encoding of returned strings

2007-05-01 Thread Mike Trotman
: Win32::OLE - ? encoding of returned strings Thanks - that's very useful. And I had missed the Unicode mode in the Win32::OLE documentation. To clarify: Part of my problem is that the MSXML XSLT transformations do NOT output the character encoding in the XML declaration. So - $xmldoc

Re: Win32::OLE - ? encoding of returned strings

2007-04-29 Thread Mike Trotman
Thanks - that's very useful. And I had missed the Unicode mode in the Win32::OLE documentation. To clarify: Part of my problem is that the MSXML XSLT transformations do NOT output the character encoding in the XML declaration. So - $xmldoc-transformNode($xsltsheet) may output Windows-1252

Re: Win32::OLE - ? encoding of returned strings

2007-04-29 Thread Foo JH
Thanks Jan, your recent tip on converting Win32::OLE-passed strings as UTF8 saved me hours of blank looks. Specifically: Win32::OLE-Option(CP = Win32::OLE::CP_UTF8()); Have a great Labour Day! Mike Trotman wrote: Thanks - that's very useful. And I had missed the Unicode mode in the

RE: Win32::OLE - ? encoding of returned strings

2007-04-27 Thread Jan Dubois
On Fri, 27 Apr 2007, Mike Trotman wrote: I am writing a CGI application that uses WIN32::OLE to interface to Microsoft ADO, MS Access, SQL Server and MSXML for XML documents and XSLT transformations. I suspect that something in the way I am passing data around (or in the ADO implementation

Re: win32::ole can't call method select on an undefined value

2007-02-02 Thread jagdish eashwar
Hi, I don't know if this is of much help, but your code is working for me after I include the usual incantations for loading WIN32::OLE at the top. jagdish eashwar ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To

RE: Win32::OLE threads

2006-05-12 Thread Jan Dubois
On Fri, 12 May 2006, ? wrote: I have the latest - 5.8.8.817 - perl installed on my Win2000 SP4. Running this script use threads; use Win32::OLE; threads-new( sub {print oops, i did it again\n} )-join; __END__ crushes perl interpreter after execution with the following message:

RE: Win32-OLE crash

2006-05-11 Thread Jan Dubois
Please try your program with ActivePerl build 817. I fixed a bug in Win32::OLE that would cause crashes in IE events, so this may be the same thing. Please confirm if the problem is gone in 817, or if it still happens. Cheers, -Jan PS: Please use plain text instead of HTML for mailing list

Re: Win32::OLE::Variant, perl crashing.

2006-05-07 Thread A. Pollock
Thanks Luke, SUPER. That's the one I was thinking about. Much better than nesting every last single call to Date() in an ungainly if/else statement. - Original Message - From: Luke Bakken [EMAIL PROTECTED] To: perl-win32-users@listserv.ActiveState.com Subject: Re: Win32::OLE

Re: Win32::OLE::Variant, perl crashing.

2006-05-06 Thread A. Pollock
Sure. if (ref ($sentdate) eq 'Win32::OLE::Variant') { # something with $sentdate-Date } else { # assume $sentdate is a string. } There might be something more efficient one can do with SUPER or AUTOLOAD or something. I've never had the time to figure it out though. - Original

Re: Win32::OLE::Variant, perl crashing.

2006-05-06 Thread Luke Bakken
if (ref ($sentdate) eq 'Win32::OLE::Variant') { # something with $sentdate-Date } else { # assume $sentdate is a string. } Best practice is to use UNIVERSAL::isa() : if (UNIVERSAL::isa($sentdate, 'Win32::OLE::Variant')) { } else { } Tested with: perl -MWin32::OLE::Variant

RE: Win32::OLE::Variant, perl crashing.

2006-05-05 Thread Timothy Johnson
Title: Win32::OLE::Variant, perl crashing. Not sure off the top of my head. Is there any way you could post some example code? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Satish Kaushik Sent: Friday, May 05, 2006 12:24 PM To:

RE: Win32::OLE::Variant, perl crashing.

2006-05-05 Thread Satish Kaushik
t;."GMT";}else{undef $sentdate;}return $sentdate; } Regards Satish From: Timothy Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 2:23 PMTo: [EMAIL PROTECTED]; perl-win32-users@listserv.ActiveState.comSubject: RE: Win32::OLE::Variant, perl crashing. Not sure off the top

RE: Win32::OLE - Mem Leak? (FIXED)

2006-03-30 Thread Paul Sobey
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Sobey Sent: 20 March 2006 11:50 To: perl-win32-users@listserv.ActiveState.com Subject: Win32::OLE - Mem Leak? I'm trying to debug a slow memory leak in a service I have written to monitor

Re: Win32::OLE and Acroread anybody?

2006-01-16 Thread Kevin Carothers
Hi Lynn, I haven't personally done this- but I've had some luck with Win32::OLE. Try $acroApp = Win32::OLE-new(AcroExch.App); $acroDoc = Win32::OLE-new(AcroExch.PDDoc); HTH- KC On 1/16/06, Lynn. Rickards [EMAIL PROTECTED] wrote: Greetings,Wondering if anyone has had any success

Re: Win32::OLE and Acroread anybody?

2006-01-16 Thread Lynn. Rickards
From: Kevin Carothers Hi Lynn, I haven't personally done this- but I've had some luck with Win32::OLE. Try $acroApp = Win32::OLE-new(AcroExch.App); $acroDoc = Win32::OLE-new(AcroExch.PDDoc); HTH- Thanks - though the first is indicated valid in acrord32.dll these and

Re: Win32::OLE and Acroread anybody?

2006-01-16 Thread Lynn. Rickards
Kevin Carothers wrote: Hi Lynn, What specifically are you trying to automate? Maybe I can try and help you find something (no promises, tho :-) KC Thanks for the thought - the aim is to open a document and either navigate to a known page or run a search. Useful-looking methods look to be

Re: Win32::Ole (MAPI) and Win2K scheduler

2006-01-05 Thread Rod Butcher
Christopher Taranto wrote: Hi Ken, Wednesday, January 4, 2006, 5:07:58 AM, you wrote: LK Thanks to Steven Manross, I'm a step further along in LK troubleshooting this. Using Steven's suggestion, I got the LK following from OLE-LastError: 'Win32::OLE(0.1403) error LK 0x80070005: Access is

RE: Win32::Ole (MAPI) and Win2K scheduler

2006-01-04 Thread LeFevre, Ken
, 2006 5:18 PM To: LeFevre, Ken; perl-win32-users@listserv.ActiveState.com Subject: RE: Win32::Ole (MAPI) and Win2K scheduler Replace : die Oops, cannot start Outlook; with open (FILE,c:\\outlookerror.txt); print FILE Oops, cannot start Outlook\n.Win32::OLE-LastError(); close (FILE); die Oops

Re: Win32::Ole (MAPI) and Win2K scheduler

2006-01-04 Thread DePriest, Jason R.
: Tuesday, January 03, 2006 5:18 PM To: LeFevre, Ken; Subject: RE: Win32::Ole (MAPI) and Win2K scheduler Replace : die Oops, cannot start Outlook; with open (FILE,c:\\outlookerror.txt); print FILE Oops, cannot start Outlook\n.Win32::OLE-LastError(); close (FILE); die Oops, cannot start

RE: Win32::Ole (MAPI) and Win2K scheduler

2006-01-03 Thread Steven Manross
Replace : die Oops, cannot start Outlook; with open (FILE,c:\\outlookerror.txt); print FILE Oops, cannot start Outlook\n.Win32::OLE-LastError(); close (FILE); die Oops, cannot start Outlook; It will help refine what error the script is throwing (and refine the possible solutions to the

Re: Win32::Ole (MAPI) and Win2K scheduler

2006-01-03 Thread Foo Ji-Haw
LeFevre, Ken wrote: I created a program using ActiveState's perl 5.8.4, compiled it using perlapp 5.3.0 and ran it on Windows 2000 Professional SP4 against Outlook 2000 SR-1 (9.0.0.3821). It runs properly both from a command prompt and as a scheduled task. I released it into production on

RE: Win32::Ole (MAPI) and Win2K scheduler

2006-01-03 Thread Steven Manross
@listserv.ActiveState.com Subject: Re: Win32::Ole (MAPI) and Win2K scheduler LeFevre, Ken wrote: I created a program using ActiveState's perl 5.8.4, compiled it using perlapp 5.3.0 and ran it on Windows 2000 Professional SP4 against Outlook 2000 SR-1 (9.0.0.3821). It runs properly both from a command prompt

RE: Win32::OLE to write macro to Excel workbook?

2005-12-30 Thread Jan Dubois
On Fri, 30 Dec 2005, Lynn. Rickards wrote: Thanks - that's a whole lot of steps in the right direction, but brings up the question what is perlCOM? I have the PDK but no sign there, and all the refs seem to indicate that is where it should be. PerlCOM used to be part of the PDK but has been

Re: Win32::OLE to write macro to Excel workbook?

2005-12-30 Thread Lynn. Rickards
Jan Dubois wrote: On Fri, 30 Dec 2005, Lynn. Rickards wrote: Thanks - that's a whole lot of steps in the right direction, but brings up the question what is perlCOM? I have the PDK but no sign there, and all the refs seem to indicate that is where it should be. PerlCOM used to be part of

RE: Win32::OLE to write macro to Excel workbook?

2005-12-29 Thread Jan Dubois
On Thu, 29 Dec 2005, Lyndon Rickards wrote: I'm looking to add some controls to a workbook, not possible using Spreadsheet::WriteExcel, with which I create the workbook. Advice, pointers anyone? Specifically Activate and deActivate routines to be written to ThisWorkbook and each of it's

RE: Win32::OLE, ADODB.Stream and ADODB.Command problem.

2005-10-12 Thread Steven Manross
Try this... $cmCmd-Properties('Output stream')-{'Value'} = $sResponseStream; I can't test it but I think that's the correct invocation. Steven -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Luke Bakken Sent: Monday, October 10, 2005 2:25 PM To:

RE: Win32::OLE(0.1701) error 0x80005000 when adding a computer to AD using Perl

2005-10-05 Thread Zeltov Alex
: Win32::OLE(0.1701) error 0x80005000 when adding a computer to AD using Perl Hmmm.. I think this is a permissions delegation issue.. Is the IIS Server trusted for delegation? This is of course a security risk... But so is opening IE.. :) Steven From: [EMAIL

RE: Win32::OLE(0.1701) error 0x80005000 when adding a computer to AD using Perl

2005-10-04 Thread Steven Manross
Hmmm.. I think this is a permissions delegation issue.. Is the IIS Server trusted for delegation? This is of course a security risk... But so is opening IE.. :) Steven From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zeltov Alex Sent: Tuesday,

RE: Win32::OLE(0.1701) error 0x80005000 when adding a computer to AD using Perl

2005-09-20 Thread Peter Guzis
The line This code works fine when I run it as a stand alone program leads me to believe it is a permission issue. Integrated Windows Authentication does not work well when your script needs to access a third system (in this case the domain controller). Try switching to basic authentication

RE: win32::ole Event handling - IE(DOM)

2005-09-16 Thread Jan Dubois
iVAN G wrote: As i read here (back from 1999) : http://aspn.activestate.com/ASPN/Mail/Message/perl-win32-users/261942 i dont seem to find this Forward method ? is it here ? Yes, it is there, just not documented, as it is just a hack... Did you actually try (and understand) the code in that

RE: Win32:OLE Excel

2005-08-05 Thread Hsu, David
] Sent: Thursday, August 04, 2005 1:47 PM To: Hsu, David Cc: Perl-Win32-Users@listserv.ActiveState.com; [EMAIL PROTECTED] Subject: RE: Win32:OLE Excel David, I have a script with almost the exact same code and it works correctly. Try removing the parens from your add statement and see

RE: Win32:OLE Excel

2005-08-05 Thread Ross Matt-QMR000
, Matt Ross Motorola Configuration Management ePIMS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hsu, David Sent: Friday, August 05, 2005 7:58 AM To: Dave Kazatsky Cc: Perl-Win32-Users@listserv.ActiveState.com; [EMAIL PROTECTED] Subject: RE: Win32:OLE Excel

RE: Win32:OLE Excel

2005-08-05 Thread Thomas, Mark - BLS CTR
Then delete all the sheets that start with sheet $SheetTabName = $Book- Worksheets($_)-{Name}; foreach ( 1...$SheetCnt) { $SheetTabName = $Book- Worksheets($_)-{Name}; if ( $SheetTabName =~ /^sheet/i ) {

RE: Win32:OLE Excel

2005-08-04 Thread Ken Barker
Try $ws1 = $workbook-add_worksheet('worksheetname'); Ken Barker IT Lead Americall Group, Inc 314-213-7927 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hsu, David Sent: Thursday, August 04, 2005 10:23 AM To:

Re: Win32:OLE Excel

2005-08-04 Thread $Bill Luebkert
Hsu, David wrote: Hi, Does someone know of another method of naming the Excel sheets? Currently I am using: ... $Worksheet = $Workbook-Worksheets()-Add(); $Worksheet-{Name} = test $i; ... The sheet names are still Sheet1, Sheet2, etc... my $workbook = $Excel-Workbooks-Add(); my

RE: Win32:OLE Excel

2005-08-04 Thread Hsu, David
Ken, I am using Win32::OLE. Add_worksheet uses the Spreadsheet:WriteExcel module. Thanks, David -Original Message- From: Ken Barker [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 12:07 PM To: Hsu, David; Perl-Win32-Users@listserv.ActiveState.com Subject: RE: Win32:OLE Excel

RE: Win32:OLE Excel

2005-08-04 Thread dkazatsky
@listserv.ActiveState.com cc: Subject: RE: Win32:OLE Excel Ken, I am using Win32::OLE. Add_worksheet uses the Spreadsheet:WriteExcel module. Thanks, David -Original Message- From: Ken Barker [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 04, 2005 12:07 PM To: Hsu, David; Perl-Win32

Re: Win32:OLE - Speech.VoiceText

2005-06-14 Thread $Bill Luebkert
Jon Bjornstad wrote: This code: use Win32::Ole; my $voice = Win32::Ole-new(Speech.VoiceText); $voice-Register('', 'Perl'); $voice-speak(hello world); STDIN;# wait til it finishes speaking has been used succesfully on Windows98 (with the Microsoft Speech SDK installed) and on

Re: Win32:OLE - Speech.VoiceText

2005-06-14 Thread Octavian Rasnita
Oh great! It works this way. Teddy - Original Message - From: Jan Dubois [EMAIL PROTECTED] To: 'Sisyphus' [EMAIL PROTECTED]; perl-win32-users@listserv.ActiveState.com; 'Jon Bjornstad' [EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 5:19 AM Subject: RE: Win32:OLE - Speech.VoiceText

Re: Win32:OLE - Speech.VoiceText

2005-06-14 Thread Octavian Rasnita
- Original Message - From: Sisyphus [EMAIL PROTECTED] To: perl-win32-users@listserv.ActiveState.com; Jon Bjornstad [EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 4:30 AM Subject: Re: Win32:OLE - Speech.VoiceText - Original Message - From: Jon Bjornstad [EMAIL PROTECTED] To: perl-win32

Re: Win32:OLE - Speech.VoiceText

2005-06-14 Thread Jon Bjornstad
: Tuesday, June 14, 2005 4:30 AM Subject: Re: Win32:OLE - Speech.VoiceText - Original Message - From: Jon Bjornstad [EMAIL PROTECTED] To: perl-win32-users@listserv.ActiveState.com Sent: Tuesday, June 14, 2005 9:26 AM Subject: Win32:OLE - Speech.VoiceText This code: use Win32::Ole; my

RE: Win32:OLE - Speech.VoiceText

2005-06-13 Thread Allegakoen, Justin Devanandan
--8--- has been used succesfully on Windows98 (with the Microsoft Speech SDK installed) and on Windows 2000 (which has it installed by default, apparently). The same code does not, however, work on Windows XP. What has changed? There IS a text-to-speech service on XP. How do I

Re: Win32:OLE - Speech.VoiceText

2005-06-13 Thread Sisyphus
- Original Message - From: Jon Bjornstad [EMAIL PROTECTED] To: perl-win32-users@listserv.ActiveState.com Sent: Tuesday, June 14, 2005 9:26 AM Subject: Win32:OLE - Speech.VoiceText This code: use Win32::Ole; my $voice = Win32::Ole-new(Speech.VoiceText); $voice-Register('', 'Perl');

RE: Win32:OLE - Speech.VoiceText

2005-06-13 Thread Jan Dubois
On Mon, 13 Jun 2005, Sisyphus wrote: - Original Message - On Tue, 14 Jun 2005, Jon Bjornstad [EMAIL PROTECTED] wrote: This code: use Win32::Ole; my $voice = Win32::Ole-new(Speech.VoiceText); $voice-Register('', 'Perl'); $voice-speak(hello world); STDIN;# wait til

Re: Win32:OLE - Speech.VoiceText

2005-06-13 Thread Jon Bjornstad
Sisyphus, Jan, all, Right. I'm sitting here copying code between an un-networked Win98 laptop, an XP machine and my Apple iBook and apologize for the sloppy copying. This code does work on Win98 (with the Speech SDK installed) and Win2000 (stock) but not on XP: use Win::OLE; my $voice =

RE: Win32:OLE - Speech.VoiceText

2005-06-13 Thread Jan Dubois
On Mon, 13 Jun 2005, Jon Bjornstad wrote: This code does work on Win98 (with the Speech SDK installed) and Win2000 (stock) but not on XP: use Win::OLE; my $voice = Win32::OLE-new('Speech.VoiceText'); die no voice: $!\n unless $voice; $voice-Register('', 'Perl'); while (STDIN) {

Re: Win32:OLE - Speech.VoiceText

2005-06-13 Thread Sisyphus
- Original Message - From: Jon Bjornstad [EMAIL PROTECTED] To: Jan Dubois [EMAIL PROTECTED] Cc: 'Sisyphus' [EMAIL PROTECTED]; perl-win32-users@listserv.ActiveState.com Sent: Tuesday, June 14, 2005 1:13 PM Subject: Re: Win32:OLE - Speech.VoiceText Sisyphus, Jan, all, Right. I'm

RE: Win32::OLE Can you call ShowOpen Method

2005-05-23 Thread Jack D.
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: May 23, 2005 7:01 PM To: perl-win32-users@listserv.ActiveState.com Subject: Win32::OLE Can you call ShowOpen Method Hello All, I would like to use OLE to access the

Re: Win32::OLE question

2005-05-09 Thread Mike G
Have you tried searching the hard drive for another version of that dll? Dll's located in a local / same folder as the application normally do not need to be registered I believe. They also get invoked before dlls in system32 or other folder. Mike At 05:29 PM 5/9/2005, Chris Cappelletti wrote:

RE: Win32 OLE issue, maybe

2005-05-04 Thread Chris Cappelletti
-How much did you copy and how did you go about it? It sounds like you partially overwrote the -second computer's copy of Win32::OLE with a different version. Try using PPM to reinstall -Win32::OLE. I didn't copy any of the perl stuff. I installed a fresh copy of perl and then used PPM to

RE: Win32 OLE issue, maybe

2005-05-04 Thread Peter Guzis
How much did you copy and how did you go about it? It sounds like you partially overwrote the second computer's copy of Win32::OLE with a different version. Try using PPM to reinstall Win32::OLE. Make sure you are only copying the modules you need. Overwriting important modules such as

RE: Win32::OLE behavior on IMessageFilter::HandleIncomingMessageSERVERCALL_RETRYLATER

2005-04-13 Thread Jan Dubois
On Wed, 13 Apr 2005, Jeff Schultz wrote: The other side of this is that calling my COM server which implements IMessageFilter from an (ATL) COM client seems to work ok. So I am guessing that perhaps ATL provides a default client implementation of IMessageFilter::RetryRejectedCall which

Re: Win32::OLE behavior on IMessageFilter::HandleIncomingMessageSERVERCALL_RETRYLATER

2005-04-13 Thread Jeff Schultz
On 4/13/05, Jan Dubois [EMAIL PROTECTED] wrote: Win32::OLE only implements OLE Automation (access to IDispatch interfaces). If you want transparent retries from scripting languages then you need to implement this in your IDispatch interface implementation yourself. Thanks for the response.

RE: Win32::OLE - Setting VBA property

2005-03-08 Thread Jan Dubois
On Tue, 08 Mar 2005, Suresh Govindachar wrote: Hello, If myDestination is a folder in Microsoft Outlook VBA code, it is possible to execute a VBA line such as the following: myDestination.Items(1).UnRead = 1 This will mark the first mail inside the folder myDestination as unread

Re: Win32:OLE - Threadsafe?

2005-02-28 Thread Kevin Carothers
On Mon, 28 Feb 2005 13:12:40 +0100, Neil Burnett [EMAIL PROTECTED] wrote: Has anything happened to solve this clean up issue with Win::OLE and threads? Free to wrong pool ... during global destruction I am avoiding the error at the moment by taking jan and paul's advice (thanks)

RE: Win32:OLE - Threadsafe?

2005-02-28 Thread Neil Burnett
-Original Message- From: Kevin Carothers [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 6:59 PM To: Neil Burnett Cc: [EMAIL PROTECTED] Subject: Re: Win32:OLE - Threadsafe? On Mon, 28 Feb 2005 13:12:40 +0100, Neil Burnett [EMAIL PROTECTED] wrote: Has anything happened

RE: Win32::OLE : Bizarre Push while Examining IE Events

2005-02-23 Thread Steven Manross
To: Andrew McFarlane Cc: perl-win32-users@listserv.ActiveState.com Subject: Re: Win32::OLE : Bizarre Push while Examining IE Events Hi Andrew, I really don't know what's going on, but I have tried running MSAccess as an OLE automation server; you too are obviously running IE as an OLE automation

RE: Win32::OLE : Bizarre Push while Examining IE Events

2005-02-23 Thread Andrew McFarlane
an exception. How do I alert the powers that be about this potential defect? Andrew McFarlane From: Steven Manross [EMAIL PROTECTED] To: Kevin Carothers [EMAIL PROTECTED],Andrew McFarlane [EMAIL PROTECTED] CC: perl-win32-users@listserv.ActiveState.com Subject: RE: Win32::OLE : Bizarre Push while

RE: Win32::OLE : Bizarre Push while Examining IE Events

2005-02-23 Thread Jan Dubois
On Wed, 23 Feb 2005, Andrew McFarlane wrote: I think that I'm seeing a but in the Win32::OLE::Lite::in method. [...] How do I alert the powers that be about this potential defect? Can you send me a complete program that I can use to reproduce the problem? Cheers, -Jan

Re: Win32::OLE : Bizarre Push while Examining IE Events

2005-02-22 Thread Kevin Carothers
Hi Andrew, I really don't know what's going on, but I have tried running MSAccess as an OLE automation server; you too are obviously running IE as an OLE automation server. I hate it when people tell me something can't be done, but I really doubt that you can call events from a COM object via a

RE: Win32::OLE-GetActiveObject not working!

2005-01-22 Thread Richard Grant
: Thursday, January 20, 2005 4:06 PM To: [EMAIL PROTECTED]; perl-win32-users@listserv.ActiveState.com Subject: RE: Win32::OLE-GetActiveObject not working! Richard, I've been having similar difficulty using Win32::OLE with Internet Explorer recently. I wrote code that worked a month ago

Re: Win32::OLE-GetActiveObject not working!

2005-01-21 Thread StoneBeat
] Behalf Of Richard Grant Sent: Thursday, January 20, 2005 3:54 PM To: perl-win32-users@listserv.ActiveState.com Subject: RE: Win32::OLE-GetActiveObject not working! I could be wrong, but I don't think iTunes is an OLE Object which could be causing your troubles. Isn't OLE Automation just

RE: Win32::OLE-GetActiveObject not working!

2005-01-21 Thread Aaron.Tesch
@listserv.ActiveState.com Subject: RE: Win32::OLE-GetActiveObject not working! I could be wrong, but I don't think iTunes is an OLE Object which could be causing your troubles. Isn't OLE Automation just a layer on COM targeted toward scripting and VB in particular? It's a shame that it doesn't have

  1   2   >