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 Win32

Win32::OLE - ? encoding of returned strings

2007-04-27 Thread Mike Trotman
Hi 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 of 'savetoxml') is not dealing correctly

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

Problem with error Can't call method Select on an undefined value in Win32::OLE Excel script

2007-02-01 Thread Glen Plantz
Hi Folks, I'm having trouble with code that I've done hundreds of times before, but which in this case is causing the error Can't call method Select on an undefined value. Here is a snippet of code: my $excel_app = Win32::OLE-new('Excel.Application') or die could not create

Re: Problem with error Can't call method Select on an undefined value in Win32::OLE Excel script

2007-02-01 Thread Jan Dubois
(); # I don't understand what I'm doing wrong. I've done things similar to this many times. This means that the call to the Range() method is failing. You should run your program with t`perl -w myscript.pl` to get more informative error messages from Win32::OLE whenever something

RE: Replacing WWW::Mechanize with Win32::OLE via IE

2006-12-15 Thread Steven Manross
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Suresh Govindachar Sent: Thursday, December 14, 2006 9:57 PM To: perl-win32-users@listserv.ActiveState.com Subject: Replacing WWW::Mechanize with Win32::OLE via IE Hello, I found two

RE: Webservice Call using Win32::OLE

2006-12-14 Thread Briggs, Larry
: Re: Webservice Call using Win32::OLE I can't give you a direct answer, but maybe you'd like to try SOAP::Lite instead. It's cross-platform (may not be relavant), and it has worked on both Java and C# web services. Briggs, Larry wrote: Hi I am trying to convert the following VB script webservice

RE: Webservice Call using Win32::OLE

2006-12-14 Thread Briggs, Larry
using Win32::OLE for: Call oServXMLHTTP.open(POST, decryptWebServiceURL, False) try: $DOM-open(POST,$decryptWebServiceUrl, 0); # 0 = false, 1 = true hope I have been some help! cheers, -Jer A Quoting Briggs, Larry [EMAIL PROTECTED]: Hi I am trying to convert the following VB script

Replacing WWW::Mechanize with Win32::OLE via IE

2006-12-14 Thread Suresh Govindachar
Hello, I found two good references for using Win32::OLE as a replacement for WWW::Mechanize on Windows (the first is by Jan Dubois): http://library.n0i.net/programming/perl/pe-rlmonth/issue3/ole_controls.html http://www.perl.com/lpt/a/916 In my application, the current page

Webservice Call using Win32::OLE

2006-12-13 Thread Briggs, Larry
Hi I am trying to convert the following VB script webservice call into perl I am trying to use Win32::OLE. Can this be done and if it can how would I go about doing this. I have provided the Perl code that I have tried to write so far. Any help that you can provide to point me in the right

Re: Webservice Call using Win32::OLE

2006-12-13 Thread mailware
into perl I am trying to use Win32::OLE. Can this be done and if it can how would I go about doing this. I have provided the Perl code that I have tried to write so far. Any help that you can provide to point me in the right direction. Const appUserID = ServiceID Const password = ServicePass

Re: Webservice Call using Win32::OLE

2006-12-13 Thread Foo JH
Win32::OLE. Can this be done and if it can how would I go about doing this. I have provided the Perl code that I have tried to write so far. Any help that you can provide to point me in the right direction. Const appUserID = ServiceID Const password = ServicePass Const appTokenName

Re: Weird win32::ole issue

2006-10-09 Thread Moby
Jan Dubois wrote: Moby writes: I translated the code to Perl as follows: # Begin Perl You should *really* insert use strict; and maybe also use warnings; use Win32::OLE; This should be: use Win32::OLE qw(in); use Win32::OLE::Variant; use Win32

Weird win32::ole issue

2006-10-06 Thread Moby
) If aLicense.LicenseID = 0003 Then wscript.echo date , time , aLicense.Name , aLicense.pooledinuse() End if Next ' End vbs I translated the code to Perl as follows: # Begin Perl use Win32::OLE; use Win32::OLE::Variant; use Win32::OLE::Const('Citrix MetaFrame COM Library

RE: Weird win32::ole issue

2006-10-06 Thread Jan Dubois
Moby writes: I translated the code to Perl as follows: # Begin Perl You should *really* insert use strict; and maybe also use warnings; use Win32::OLE; This should be: use Win32::OLE qw(in); use Win32::OLE::Variant; use Win32::OLE::Const('Citrix MetaFrame COM Library

error when I try to execute the SaveAs function in Win32::OLE when I try to save an Excel worksheet to a new format.

2006-10-04 Thread Glen Plantz
Title: error when I try to execute the SaveAs function in Win32::OLE when I try to save an Excel worksheet to a new format. Hi Folks, I'm getting an error when I try to execute the SaveAs function in Win32::OLE when I try to save an Excel worksheet to a new format. ( I'm using the csv

Re: error when I try to execute the SaveAs function in Win32::OLE when I try to save an Excel worksheet to a new format.

2006-10-04 Thread work
Quoting Glen Plantz [EMAIL PROTECTED]: Hi Folks, I'm getting an error when I try to execute the SaveAs function in Win32::OLE when I try to save an Excel worksheet to a new format. ( I'm using the csv format here, but I _really_ want to save each sheet in the workbook as a Tab delimited

RE: Seeking help with Win32::OLE and tlbinf32 COM library

2006-08-07 Thread Jan Dubois
of Tlbinf32 objects is build in methods to Win32::OLE::CONST to accomplish the same things. Frankly most of these exports seem almost hidden to me, but you can find samples of their use buried here and there in modules. Hi Mark, I'm surprised that this has never been pointed out directly to me. I

Seeking help with Win32::OLE and tlbinf32 COM library

2006-08-06 Thread Jamal Mazrui
, produces the following error message: Win32::OLE(0.1703) error 0x80004002: No such interface supported at tlbinf.pl line 8. As the commented lines below indicate, I have tried initializing the OLE system with the single threaded or co-initialize constant instead, but get the same result. I also

Re: Seeking help with Win32::OLE and tlbinf32 COM library

2006-08-06 Thread mark pryor
uncountable amounts of time running into this same brick wall. Back in Winter-2004 I wrote a small page about it and I have recently restored it to my site. What Active State has done in place of Tlbinf32 objects is build in methods to Win32::OLE::CONST to accomplish the same things. Frankly most o

RE: Resolved - Question about Win32::OLE

2006-05-26 Thread robert . w . sturdevant
Title: RE: Resolved - Question about Win32::OLE After screwing up the last two days, I now have this well embedded in my mind. Wel, at least until I have another memory dump. This list is a great resource. Best to all, Sturdy -Original Message- From: Timothy Johnson

RE: Question about Win32-OLE

2006-05-25 Thread robert . w . sturdevant
Title: Question about Win32-OLE Hi Timothy, Thanks for the response. Here is the error trapping added (changed die to warn) which produces the output as I originally stated. $SFTPServer-connect( $Server, $Port, $UserName, $Password ) or warn Could not connect as $UserName to $Server

RE: Question about Win32-OLE

2006-05-25 Thread robert . w . sturdevant
Title: RE: Question about Win32-OLE Hi Nick, Thanks for your thoughts (it was a looong day). I did both. I trapped LastError after instantiating the object and new() does not throw an error. However, I can't tell if it is occurring correctly. Sturdy -Original Message- From

RE: Question about Win32-OLE

2006-05-25 Thread robert . w . sturdevant
Title: Question about Win32-OLE Hi Jan, Thanks for the assist. I apologize for the HTML. I'm using Outlook and it is set for "Plain Text" so I don't yet know where the HTML is coming from. This is a company computer so much of the configuration is locked in. I'll try to find t

RE: Question about Win32-OLE

2006-05-25 Thread D D Allen
While this shouldn't make a difference, as I found out recently with a Win32::OLE script that I was working on, it can make a difference (pointed out by Jan Dubois). Change the extension of your test script to .pls and then run it using WSH / cscript: C:\my perl scriptscscript test.pls Regards

Resolved - Question about Win32::OLE

2006-05-25 Thread robert . w . sturdevant
Title: Resolved - Question about Win32::OLE First, thanks to all who offered their assistance. I spent many hours trying to make my simple test script work...and it does (did)! Darn thing had been working all the time (very embarassing). The problem seems to be die or warn in this line

RE: Resolved - Question about Win32::OLE

2006-05-25 Thread Bharucha, Nikhil
Win32::OLE First, thanks to all who offered their assistance. I spent many hours trying to make my simple test script work...and it does (did)! Darn thing had been working all the time (very embarassing). The problem seems to be die or warn in this line: $SFTPServer-connect( $Server, $Port, $UserName

RE: Resolved - Question about Win32::OLE

2006-05-25 Thread robert . w . sturdevant
Title: RE: Resolved - Question about Win32::OLE Hi Nick, Take a look at the API doc for whatever SFTP program you are accessing; it may be returning values you are not expecting. After you instantiate via the new method in OLE you are passed back whatever the external program passes

RE: Resolved - Question about Win32::OLE

2006-05-25 Thread Timothy Johnson
on success. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 25, 2006 8:15 AM To: [EMAIL PROTECTED] Cc: perl-win32-users@listserv.ActiveState.com Subject: RE: Resolved - Question about Win32::OLE Hi Nick

RE: Resolved - Question about Win32::OLE

2006-05-25 Thread Timothy Johnson
This isn't really a Win32::OLE issue. There are two different philosophies when it comes to returning success or error from a function: 1. The kind of function you run into most frequently in Perl is the kind that will return a false value on error (usually 0), and a true value on success

Question about Win32-OLE

2006-05-24 Thread robert . w . sturdevant
Title: Question about Win32-OLE Hi all, I am having a problem accessing a commercial SFTP server app (non-MS). My code is below. I can instantiate the object but the connect method refuses to establish the connection. use Win32::OLE; my $Server = localhost; my $Port = 1000; my $UserName

RE: Question about Win32-OLE

2006-05-24 Thread Timothy Johnson
Title: Question about Win32-OLE Are you sure that the connect method is returning a non-zero value on success? What happens if you take out the die clause? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 11:59 AM

RE: Question about Win32-OLE

2006-05-24 Thread Jan Dubois
Title: Question about Win32-OLE It is not clear that the Connect() call failed. Is it defined to return a true value if it succeeds? Your _vbscript_ code is not checking the return code of Connect() at all. If the connection is indeed failing, then you should try to print out Win32::OLE

RE: Question about Win32-OLE

2006-05-24 Thread Bharucha, Nikhil
Of [EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 2:59 PM To: perl-win32-users@listserv.ActiveState.com Subject: Question about Win32-OLE This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. connect method refuses

Win32::OLE threads

2006-05-12 Thread Артем Аветисян
Hi, all. 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: Free to wrong pool 1a43338

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: How to query interface by Win32::OLE.

2006-05-10 Thread like
interface by Win32::OLE. On Sat, 06 May 2006, Like Ma wrote: Hi Jan, I am sure that it does. I can call the methods of IJob, but I can't call any method of ISourceCollection. Is there a method in Win32::OLE like QueryInterface in C++ ? There is an undocumented QueryInterface method in Win32::OLE

RE: How to query interface by Win32::OLE.

2006-05-10 Thread Jan Dubois
, 06 May 2006, Like Ma wrote: Hi Jan, I am sure that it does. I can call the methods of IJob, but I can't call any method of ISourceCollection. Is there a method in Win32::OLE like QueryInterface in C++ ? There is an undocumented QueryInterface method in Win32::OLE but it will not do you any

Win32-OLE crash

2006-05-10 Thread kannan r
Using Win32-OLE for automation results in crash of perl. The scenario is as follows. Create an IE object subscribe for the events my $IE = Win32::OLE-new(InternetExplorer.Application)|| die Could not start Internet Explorer.Application\n; Win32::OLE-WithEvents($IE,\CaptureEvent

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

How to query interface by Win32::OLE.

2006-05-06 Thread Like Ma
Hi Everyone, I want to communicate with COM, that is the following: coclass CJob { interface IJob; interface ISourceCollection; }; by Win32::OLE like $job = Win32::OLE-new ('SyncService.Job.1') || die Unable to create job.\n; if (Win32::OLE-LastError != 0) { print Unable to new a job

RE: How to query interface by Win32::OLE.

2006-05-06 Thread Jan Dubois
On Sat, 06 May 2006, Like Ma wrote: I want to communicate with COM, that is the following: coclass CJob { interface IJob; interface ISourceCollection; }; by Win32::OLE like $job = Win32::OLE-new ('SyncService.Job.1') || die Unable to create job.\n; if (Win32::OLE-LastError != 0

Re: How to query interface by Win32::OLE.

2006-05-06 Thread Like Ma
Hi Jan, I am sure that it does. I can call the methods of IJob, but I can't call any method of ISourceCollection. Is there a method in Win32::OLE like QueryInterface in C++ ? Thanks, Like On 5/7/06, Jan Dubois [EMAIL PROTECTED] wrote: On Sat, 06 May 2006, Like Ma wrote: I want

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 -e$v=Win32

Win32::OLE::Variant, perl crashing.

2006-05-05 Thread Satish Kaushik
Title: Win32::OLE::Variant, perl crashing. Hi Everyone, I am using this module for the dates. While testing I came acorss one date which was not a Variant, PERL died saying can't call 'Date' method . I tried to get the 'Type' from the string but again since given string is not a 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: perl-win32-users

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

2006-05-05 Thread Satish Kaushik
Title: Win32::OLE::Variant, perl crashing. Hi Timothy, Thanks for your response. This is a subroutine, where I am getting this problem while accessing Date method. sub process_date_variant{my $inputvar =shift; my $sentvariant = Variant(VT_DATE,'Jan 1, 1970 3:00 pm');my($convertdate

Re: Returning to a Worksheet where a hyperlink was used - in Excel with Win32::OLE

2006-05-03 Thread Сергей Черниенко
Здравствуйте Glen, Monday, May 01, 2006, 11:47:28 PM, Вы написали: GP I know that the user can get back to a Sheet from where they originally GP clicked on the hyperlink ( that brought them to the current definition GP page ) by executing: GP Control-G ENTER It

RE: Returning to a Worksheet where a hyperlink was used - in Excelwith Win32::OLE

2006-05-03 Thread Timothy Johnson
Nice. Here's the code in Perl (untested, but it should be the same). use Win32::OLE; my $xl = (Win32::OLE-GetActiveObject('Excel.Application') || Win32::OLE-new('Excel.Application')); $xl-Application-Goto({Reference = $xl-Application

Returning to a Worksheet where a hyperlink was used - in Excel with Win32::OLE

2006-05-01 Thread Glen Plantz
Title: Returning to a Worksheet where a hyperlink was used - in Excel with Win32::OLE Hi Folks, We have a set of Excel Workbooks that are constructed by Perl Win32::OLE scripts. The Workbooks consist of reports in the form of Worksheets. Each Worksheet has a column of Hyperlink Objects

Win32::OLE Microsoft Outlook - Support Task and Calendar Applications?

2006-04-03 Thread rcsalazar
Hi: I'm sorry my English? I need to know if Win32::OLE - Microsoft Outlook, support Tasks and Calendar options? (New Tasks, New Events, Notes). I have only found examples of Send Mail with Outlook with attachments if support exist, please I need a example. Regards and Thanks, Roberto

Re[2]: Win32::OLE Microsoft Outlook - Support Task and Calendar Applications?

2006-04-03 Thread Christopher Taranto
the user before continuing the script, check out Outlook Redemption: http://www.dimastr.com/redemption/ HTH, Christopher Taranto Monday, April 3, 2006, 4:35:32 PM, you wrote: ran Hi: ran I'm sorry my English? ran I need to know if Win32::OLE - Microsoft Outlook, support Tasks ran and Calendar

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

Modifying the Address property of an Excel Hyperlink object with Win32::OLE

2006-03-29 Thread Glen Plantz
Title: Modifying the Address property of an Excel Hyperlink object with Win32::OLE Hi folks, I need to edit the Address property of Hyperlink objects in Excel worksheets. I did a google and found several examples of ADDING hyperlinks, but could someone please send me an example of editing

Re: Modifying the Address property of an Excel Hyperlink object with Win32::OLE

2006-03-29 Thread D D Allen
The 1,100+ page book Excel 2003 VBA has only minimal information on Hyperlinks. As Hyperlinks are a collection, I believe you need to use Win32::OLE::Enum to be able to iterate through all of the Hyperlink objects on a given worksheet. Once you find the right Hyperlink object (based

FW: Win32::OLE - Mem Leak?

2006-03-24 Thread Paul Sobey
@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 performance counters on my servers. The service queries several wmi every 5 seconds, and exhibits a very slow leak, such that processes grow to a 100MB in size after a few weeks

Win32::OLE - Mem Leak?

2006-03-20 Thread Paul Sobey
I'm trying to debug a slow memory leak in a service I have written to monitor performance counters on my servers. The service queries several wmi every 5 seconds, and exhibits a very slow leak, such that processes grow to a 100MB in size after a few weeks. I think I have pinned down the leak to

Win32::OLE and Acroread anybody?

2006-01-16 Thread Lynn. Rickards
Greetings, Wondering if anyone has had any success controlling Adobe Acroreader thru OLE. There appears to be limited functionality exposed, as seen in OLE browser, but I didn't get past the first hurdle $acroApp = Win32::OLE-new('???'); Any clue most welcome. TIA - Lynn

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

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

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

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

2006-01-04 Thread LeFevre, Ken
Thanks to Steven Manross, I'm a step further along in troubleshooting this. Using Steven's suggestion, I got the following from OLE-LastError: 'Win32::OLE(0.1403) error 0x80070005: Access is denied'. Does anyone out there know anything about how the Win2k scheduler accesses objects (and, more

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

2006-01-04 Thread DePriest, Jason R.
On 1/4/06, LeFevre, Ken wrote: Thanks to Steven Manross, I'm a step further along in troubleshooting this. Using Steven's suggestion, I got the following from OLE-LastError: 'Win32::OLE(0.1403) error 0x80070005: Access is denied'. Does anyone out there know anything about how the Win2k

Re[2]: Win32::Ole (MAPI) and Win2K scheduler

2006-01-04 Thread Christopher Taranto
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 denied'. Does anyone out

Win32::Ole (MAPI) and Win2K scheduler

2006-01-03 Thread LeFevre, Ken
SP4 using the identical version of Outlook 2000. Again, it runs great from a command prompt. When I run it as a scheduled task, however, it dies because it's not able to get the Outlook Application. Here's the relevant code: Win32::OLE-Initialize(Win32::OLE::COINIT_OLEINITIALIZE); die Win32

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

2006-01-03 Thread Steven Manross
to the problem). Steven From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeFevre, Ken Sent: Tuesday, January 03, 2006 1:01 PM To: perl-win32-users@listserv.ActiveState.com Subject: Win32::Ole (MAPI) and Win2K scheduler I created a program using ActiveState's

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

2006-01-03 Thread Foo Ji-Haw
part, but it does not happen for Outlook 2000. Here's the relevant code: Win32::OLE-Initialize(Win32::OLE::COINIT_OLEINITIALIZE); die Win32::OLE-LastError(),\n if Win32::OLE-LastError( ); eval { $Outlook = Win32::OLE-GetActiveObject('Outlook.Application') }; die

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

Win32::OLE to write macro to Excel workbook?

2005-12-29 Thread Lyndon Rickards
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 worksheets. Recording a macro adding code, just

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

Help with Win32::OLE SAPI5 SPeech Recognition HASH

2005-12-24 Thread Karl Hilts
Hi Folks, My question today has to do with Win32::OLE and SAPI5 speech recognition. This is not a SAPI question but is a Perl question. I believe that I've accomplished my task of capturing speech recognition events but am unable to convert the HASH to text. I'm able to run my code

using Win32::OLE to copy or copy a range from one sheet to another

2005-12-06 Thread Glen Plantz
Title: Message Hi Folks, I've been using Perl for a number of years, and I'm now learning Win32::OLE for manipulating Excel files. I'm try to copyor cut a range of cells from one Worksheet to another. The "Select" portion works fine, but the "Paste" is not working.

RE: using Win32::OLE to copy or copy a range from one sheet to another

2005-12-06 Thread Allegakoen, Justin Devanandan
; use warnings; # Don't need these, but good to load as your code gets bigger use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; use Win32::OLE::Variant; $Win32::OLE::Warn = 3; my $Excel_CSAA_Test_Retrieve = 'C:\Temp\Temp.xls'; my $excel_app

Win32::OLE and IE popups

2005-11-26 Thread Richard Bell
that works? Test code #!/usr/bin/perl -w # # use local version of mech with alternate page completion logic # use strict; use Time::HiRes qw(gettimeofday); use URI; use Win32::OLE qw( EVENTS in with valof ); use Win32::OLE::Variant; my $t_start; my $tend = gettimeofday; my $url

Win32::OLE : PageSetup question for PowerPoint

2005-10-17 Thread VnPenguin
Hi all, I'm trying to define paper size for PowerPoint with Win32::OLE. The code is: ... my $PptApp = Win32::OLE-GetActiveObject('PowerPoint.Application') || Win32::OLE-new('PowerPoint.Application', 'Quit'); $PptApp-{Visible} = 1; my $Presentation = $PptApp-Presentations-Add

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

2005-10-12 Thread Steven Manross
-win32-users@listserv.ActiveState.com; beginners@perl.org Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Win32::OLE, ADODB.Stream and ADODB.Command problem. Hello all, I'm trying to use Win32::OLE (version 0.1703) and the ADODB objects to retrieve XML being produced by a stored procedure on SQL

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
, September 20, 2005 1:06 PM To: perl-win32-users@listserv.ActiveState.com Subject: Win32::OLE(0.1701) error 0x80005000 when adding a computer to AD using Perl I am running into a problem, when I execute a simple script to add a computer to an AD when I do it through a cgi script. This is the code

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

2005-09-20 Thread Zeltov Alex
ab,DC=siemensmedasp,DC=com";my $strComp = "alex"; # e.g. joe-xpmy $strDescr = "none"; # e.g. Joes Windows XP workstationuse Win32::OLE;$Win32::OLE::Warn = 3;# $ADS_USER_FLAG_ENUMmy $ADS_UF_WORKSTATION_TRUST_ACCOUNT = 0x1000;my $objCont = Win32::OLE-GetObject(&qu

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

2005-09-20 Thread Peter Guzis
and see if you have better luck. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zeltov Alex Sent: Tuesday, September 20, 2005 1:06 PM To: perl-win32-users@listserv.ActiveState.com Subject: Win32::OLE(0.1701) error 0x80005000 when adding a computer to AD using

win32::ole Event handling - IE(DOM)

2005-09-16 Thread iVAN G
hi, 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 ? Now what next , I want to recieve all DOM generated events and act on them. The event sink way will not work very well here !! OK i

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: [OLE] Win32::OLE messes up dialogs?

2005-09-02 Thread Zorg, the Borg
2005/9/2, Jan Dubois [EMAIL PROTECTED]: i'm experiencing some strange problems when using the module Win32::OLE together with windows dialogs. Please call Win32::OLE-Initialize(Win32::OLE::COINIT_OLEINITIALIZE); works perfectly, thanks. ciao davide

[OLE] Win32::OLE messes up dialogs?

2005-09-01 Thread Zorg, the Borg
Hi all, this is a copy of a message that I posted to comp.lang.perl.misc. i'm experiencing some strange problems when using the module Win32::OLE together with windows dialogs. In the following code snippet, I use an opendialog to pick a file. The dialog works as expected: when a different file

Re: [OLE] Win32::OLE messes up dialogs?

2005-09-01 Thread $Bill Luebkert
Zorg, the Borg wrote: Hi all, this is a copy of a message that I posted to comp.lang.perl.misc. i'm experiencing some strange problems when using the module Win32::OLE together with windows dialogs. In the following code snippet, I use an opendialog to pick a file. The dialog works

RE: [OLE] Win32::OLE messes up dialogs?

2005-09-01 Thread Jan Dubois
On Thu, 01 Sep 2005, Zorg, the Borg wrote: i'm experiencing some strange problems when using the module Win32::OLE together with windows dialogs. In the following code snippet, I use an opendialog to pick a file. The dialog works as expected: when a different file type is selected

RE: Problem With Win32::OLE and InternetExplorer.Application

2005-08-31 Thread Steven Manross
: Problem With Win32::OLE and InternetExplorer.Application It must be with InternetExplorer.Application. I have tryed with Microsoft.XMLHTTP and it works but, this object dont use Internet Explorer and for my project i must use it. Thanks Bill El Jueves 14 Julio 2005 03:30, $Bill Luebkert escribio

Re: [OLE] Win32::OLE can't capture events from SAPI5 COM objects

2005-08-25 Thread Jouke Visser
Hi, MSAgent works just fine from Perl; it is just the event stuff that is problematic. I know, I wrote Win32::MSAgent ;-) The win32com module for Python implements a lot more stuff than Win32::OLE. I did want to figure out why MSAgent events didn't work for Perl, but never really wanted

Re: [OLE] Win32::OLE can't capture events from SAPI5 COM objects

2005-08-24 Thread Jouke Visser
Sorry, no idea (and no time to dig into it now either). I remember that using events with MS Agent objects didn't work correctly with Win32::OLE, but didn't ever spend the time to figure that one out either. I believe those objects needed to be embedded in a real GUI application to fire events

RE: [OLE] Win32::OLE can't capture events from SAPI5 COM objects

2005-08-24 Thread Jan Dubois
On Wed, 24 Aug 2005, Jouke Visser wrote: Sorry, no idea (and no time to dig into it now either). I remember that using events with MS Agent objects didn't work correctly with Win32::OLE, but didn't ever spend the time to figure that one out either. I believe those objects needed

RE: [OLE] Win32::OLE can't capture events from SAPI5 COM objects

2005-08-23 Thread Jan Dubois
gets called. I'm pretty sure the code is OK (I've attached a sample script), so I think it must be the Win32::OLE module that of course has only Alpha support for events. I've seen a similar posting in perl-win32-users a rather long time ago that didn't get any response, so I'm trying again

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

<    1   2   3   4   5   >