RE: Win32 OLE modification of component identity

2004-05-03 Thread Miguel Laborde
No go unfortunately.. I get the following error: Found component Win32::OLE=HASH(0x1f91e70) Check1 retrying default method at C:/Perl/site/lib/Win32/OLE/Lite.pm line 156. Check2 after modifying the code with: print Check1\n; $COMComponent-SetInfo(); print Check2\n; From the VB Code the call

RE: Win32 OLE modification of component identity

2004-05-03 Thread Steven Manross
You should really start using Win32::OLE-LastError() to see what and where it doesn't like the code. i.e. if (Win32::OLE-LastError() != 0) { print 1: .Win32::OLE-LastError().\n; } Steven -Original Message- From: Miguel Laborde [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 11

RE: Win32 OLE modification of component identity

2004-05-03 Thread Miguel Laborde
Thanks Steven, I did as you suggested. The result is: retrying default method at C:/Perl/site/lib/Win32/OLE/Lite.pm line 156. 1: Win32::OLE(0.1403) error 0x80020003: Member not found in METHOD/PROPERTYGET Having a look on Microsoft's website gives a link to this http

RE: Win32 OLE modification of component identity

2004-05-03 Thread Steven Manross
] Subject: RE: Win32 OLE modification of component identity No go unfortunately.. I get the following error: Found component Win32::OLE=HASH(0x1f91e70) Check1 retrying default method at C:/Perl/site/lib/Win32/OLE/Lite.pm line 156. Check2 after modifying the code with: print Check1\n; $COMComponent

RE: Win32 OLE modification of component identity

2004-05-03 Thread Miguel Laborde
Hi Steven, unfortunately this doesn't seem to work. When I try this way I get: Found component Win32::OLE=HASH(0x1f90eb8) 1: Win32::OLE(0.1403) error 0x8002000e: Invalid number of parameters in PROPERTYPUT Value when the preceeding line

RE: Win32 OLE modification of component identity

2004-05-03 Thread Steven Manross
to be set. You've reached the end of my rope. I don't know where to go from here. Sorry. Steven -Original Message- From: Miguel Laborde [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 12:52 PM To: Steven Manross; [EMAIL PROTECTED] Subject: RE: Win32 OLE modification of component

RE: Win32 OLE modification of component identity

2004-05-03 Thread Steven Manross
'; [EMAIL PROTECTED] Subject: RE: Win32 OLE modification of component identity Try something like this. $COMComponent-{Value}-{Identity} = $varUserStr; $COMComponent-{Value}-{Password} = $varPasswordStr; There seems to be no Identity property on the Com Component Object, instead

RE: Win32 OLE modification of component identity

2004-05-03 Thread Jan Dubois
an indexed property. The correct syntax to assign to them would be $COMComponent-LetProperty(Value, Identity, $varUserStr); Value is the property name, Identity is the first (and only) argument to the property, and $varUserStr is the new value. Some general hints about using Win32::OLE

Re: Win32::OLE and events from multiple source interfaces

2004-04-19 Thread Rajkumar Malli
of these connection points, one at a time. Is it possible to get events from both? The WithEvents call on one interface seems to overwrite the WithEvents call on the other interface. Yes, Win32::OLE only supports one connection point per object. Cheers, -Jan Is this not a limitation

Re: Win32::OLE and events from multiple source interfaces

2004-04-16 Thread Jan Dubois
and IAsiaTestEvent along which it can fire COM events . Now, I can get events from either of these connection points, one at a time. Is it possible to get events from both? The WithEvents call on one interface seems to overwrite the WithEvents call on the other interface. Yes, Win32::OLE only supports one

Win32::OLE and events from multiple source interfaces

2004-03-31 Thread Rajkumar Malli
on one interface seems to overwrite the WithEvents call on the other interface. Here is my code: use strict; use warnings; use Win32::OLE qw(EVENTS); my $progID = SampleServer.SampleInterface.1; my $server = Win32::OLE-new($progID); Win32::OLE-WithEvents($server, \MyHandler, 'IAsiaTestEvent'); Win32

Re: Win32::OLE and events from multiple source interfaces

2004-03-31 Thread Jan Dubois
at a time. Is it possible to get events from both? The WithEvents call on one interface seems to overwrite the WithEvents call on the other interface. Yes, Win32::OLE only supports one connection point per object. Cheers, -Jan ___ Perl-Win32-Users mailing list

Re: 255 char limit Win32::OLE Microsoft Word?

2004-02-25 Thread Ryan Nowakowski
I'm doing this to init the word object: my $mswordapp = Win32::OLE-GetActiveObject('Word.Application') || Win32::OLE-new('Word.Application', 'Quit') or die Can´t start Microsoft Word: . Win32::OLE-LastError(); $mswordapp('word')-Documents-Open('myworddoc.doc') or die

perl win32 ole question

2004-02-18 Thread chiesa
hi,all first,my english is poor. the question is as below: i have to use one COM in perl. the COM is defined as below (i get it from vc): --- struct __declspec(uuid(94c6417e-fcaa-4b13-abbe-f708c6705234)) IXXXParams : IDispatch {

Win32:OLE Excel last row question.

2004-02-13 Thread Beckett Richard-qswi266
Guys, This line successfully gives me the last used row in a populated spreadsheet: my $LastRow = $sheet-UsedRange-Find({What=*, SearchDirection=xlPrevious, SearchOrder=xlByRows})-{Row}; However, if the spreadsheet in empty, I get the following error: Can't use an undefined value as a HASH

Win32::OLE Excel: TypeName

2004-02-06 Thread armin . nolte
Hi, does soemone know how I can get the type of an Excel-Sheet via perl. I have to know whether a Sheet is a 'Chart' or a 'Worksheet'. In Visual Basic there is The 'TypeName'-Function. But I don't get this Function to call from my perl Cheers Armin

RE: Win32 OLE: How to get content from a MSIE frame?

2004-02-03 Thread Jing Wee
Hi Steven Thank you very much for your response and leading me to the answer! I did not get it work with the codes you provided due to error when I ran it: retrying default method at C:/Perl/site/lib/Win32/OLE/Lite.pm line 156. Can't call method item on an undefined value at C:\test.pl line 14

RE: Win32::OLE: how to extract contents of Visual C++ 6.0 Build window?

2004-01-30 Thread Jon McAllister
I wasn't clear about exactly what I'm doing. I am writing a script to automate nightly Visual C++ 6.0 builds. I appreciate the suggestions, but I remain convinced that using Win32::OLE is the best solution. If I use NMAKE, that just replaces the minor problem that I asked about

Can't use an undefined value as a HASH reference when using Win32 ::OLE

2004-01-26 Thread Hsu, David
n if I run it again, it executes fine. But run it again, it gives the same error. So, it's executing successfully on every other execution. Here is the code, it is choking when I rename my Excel sheet name. I can't figure it out. Thanks, David use Win32::OLE; unlink($path) if (-e $path)

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-12 Thread Steven Manross
PM To: Steven Manross; Perl-Win32-Users (E-mail) Subject: RE: Using Win32::OLE and Outlook to *resend* a message Steven, thanks for the code example. However, I do see the same problem with your code that I'm experiencing. If the spam you received is in HTML format (as many

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-12 Thread Tony White
Win32::OLE and Outlook to *resend* a message Yes on both accounts... The procedure to create the text files should be automated and is very easily done... The only human intervention in the process should be the users moving the message to a folder, and someone verifying the users

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-12 Thread Tony White
:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:07 PM To: Tony White; Perl-Win32-Users (E-mail) Subject: RE: Using Win32::OLE and Outlook to *resend* a message I use: sub GetMessageText { my $message = $_[0]; my $oFields = $message-Fields(); if ($oFields) { if ($oFields

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-12 Thread Steven Manross
{ print No Fields\n; return 0; } } Steven -Original Message- From: Tony White [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 9:40 AM To: Steven Manross; Perl-Win32-Users (E-mail) Subject: RE: Using Win32::OLE and Outlook to *resend* a message Steven, I just found a problem

Using Win32::OLE and Outlook to *resend* a message

2004-01-09 Thread Tony White
Everyone, I've spent nearly a week researching how to go about programmatically resending a message via Outlook. Not reply or forward - I mean RESEND. Resending a message is the only way to keep the Internet headers and original message intact when using Outlook / Exchange. I've poured over

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-09 Thread Steven Manross
a working solution based on this principle in production. Steven -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony White Sent: Friday, January 09, 2004 1:02 PM To: Perl-Win32-Users (E-mail) Subject: Using Win32::OLE and Outlook to *resend* a message

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-09 Thread Tony White
(E-mail) Subject: Using Win32::OLE and Outlook to *resend* a message Everyone, I've spent nearly a week researching how to go about programmatically resending a message via Outlook. Not reply or forward - I mean RESEND. Resending a message is the only way to keep the Internet headers

RE: Using Win32::OLE and Outlook to *resend* a message

2004-01-09 Thread Steven Manross
[mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:46 PM To: Steven Manross; Perl-Win32-Users (E-mail) Subject: RE: Using Win32::OLE and Outlook to *resend* a message H you may be right. Although I would automate the procedure that you mention (i.e., I would automate the saving

Re: trying to use win32::OLE with alt credentials for AD.

2003-10-21 Thread Simon Whitaker
: - could also be GC: my $objAD = Win32::OLE-GetObject( $1 ); $obj = $objAD-OpenDSObject( $adspath, $username, $password, 1 ); } else { print Getting object without authentication\n if $DEBUG; $obj = Win32::OLE-GetObject( $adspath ); } On Tuesday, October 21, 2003

Help With Appending Word Doc Using Win32::OLE

2003-10-06 Thread Frank Howard
for ... The goal is to retrieve a document, append a new table to it at various times, then re-save ... Here's what I have so far ... sub AppendWordDocument { use Win32::OLE; use Win32::OLE::Const 'Microsoft Word'; my $ObjectClass = Word.Application; my $File = c:\\doclocation\\testmerge.doc; my

RE: Win32::OLE

2003-09-18 Thread Groenwold, Harmen (ICT) (HK)
Hi, This took me a while to figure out, but I think I got the solution to your problem. First, the Win32::Process, Win32::Process::Info or even Win32::OLE seem not to help in any way to achieve what you want. I've gone through quite some VBA documentation for Outlook and it seems that VBA doesn't

RE: Win32::OLE

2003-09-18 Thread Martin Bower
: Martin Bower [mailto:[EMAIL PROTECTED] Sent: 18 September 2003 15:39 To: 'Groenwold, Harmen (ICT) (HK)'; [EMAIL PROTECTED] Subject: RE: Win32::OLE cool, thanks v much. I just googled and added the following 2 lines to restore the window to its previous position if it had been minimsed. my

Win32::OLE Access 2000 Connection problem

2003-09-12 Thread Fernando Freire Baez (Medicare)
Hello, I have an script that connect to a Access database using Win32::OLE. The admin move the convert the database to Access 2000 and configure a userid and password to connecto to it. Now the script fails in the execution with an error in the connection. Here the evariables tha hold

Where's Win32::OLE docs? And here's how to merge cells in Excel

2003-08-25 Thread Randy Strauss
Is there some way to find decent docs on what perl can access? The VB Editor's object browser, when I look for Merge tells me that there are 3 members of the Range object that might work: Property MergeCells As Variant Property MergeArea As Range read-only Member of Excel.Range Sub

Re: Win32::OLE Microsoft Excel

2003-08-25 Thread armin . nolte
] Gesendet von: Kopie: [EMAIL PROTECTED]Thema:Win32::OLE Microsoft Excel veState.com

Win32::OLE Microsoft Excel

2003-08-21 Thread Pete Roberts
I thought I had this cracked.. but no. Does anyone have any idea at all at all why assigning array values to: $Chart-SeriesCollection(id)-XValues = [EMAIL PROTECTED] $Chart-SeriesCollection(id)-Values = [EMAIL PROTECTED] sometimes works and sometimes doesn't ? A workaround is to put the

Re: Win32-OLE excel cell reference.

2003-08-14 Thread $Bill Luebkert
Beckett Richard-qswi266 wrote: Guys, I'm struggling with the syntax to point to the cells that I want to use in Excel. It seems that the Range command likes data like (A14), or (A14:B26), and I am happy with this. My problem occurrs when I only have numeric data to work with, because

RE: Win32-OLE excel cell reference.

2003-08-14 Thread Ross Matt-QMR000
Richard-qswi266'; [EMAIL PROTECTED] Subject: RE: Win32-OLE excel cell reference. From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED] Subject: Win32-OLE excel cell reference. It seems that the Range command likes data like (A14), or (A14:B26), and I am happy with this. My problem

RE: Win32-OLE excel cell reference.

2003-08-10 Thread Charbeneau, Chuck
From: Ross Matt-QMR000 [mailto:[EMAIL PROTECTED] Subject: RE: Win32-OLE excel cell reference. by no means did mean anything negative about what you wrote in reply. You have ALWAYS been very helpful to me and others with your posts. No worries. I didn't take any offense, just offering

RE: Win32-OLE excel cell reference.

2003-08-10 Thread Charbeneau, Chuck
From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED] Subject: Win32-OLE excel cell reference. It seems that the Range command likes data like (A14), or (A14:B26), and I am happy with this. My problem occurrs when I only have numeric data to work with, because of incremented

win32::ole open, copypaste, create new, save document

2003-07-25 Thread Deac Nkisetlein
Dear listmembers, searching the webarchives did not bring up an answer to my question. Please take in consideration, that Iam completely new to win32:ole. I managed to open documents, print them to ps-output and things like that so far (to batch-convert doc to pdf). Now Iam searching

Re: win32::ole open, copypaste, create new, save document

2003-07-25 Thread work
Now Iam searching for the solution to do the following with win32::ole -open .doc file- no problem -make and copy a range of pages- problem -create a new document - no problem -paste into new document- problem -close

Outlook : name resolve conflict win32 ole

2003-07-16 Thread Rahul Chauhan
Friends I am trying to composeand senda mail automatically using perl win32::ole. I form the "To" list of mail using the aliases of users.When the mail is sent;I get an error something like this ---8X OLE exception from "Microsoft Outlook": Outlook does not r

Outlook : name resolve conflict win32 ole

2003-07-16 Thread Rahul Chauhan
Friends I am trying to composeand senda mail automatically using perl win32::ole. I form the "To" list of mail using the aliases of users.When the mail is sent;I get an error something like this ---8X OLE exception from "Microsoft Outlook&q

RE: Using Outlook in Win32::OLE

2003-06-22 Thread Bautista, Rodel D.\(Digitel-GSM\)
Hi to all, With the request of Sir Steve Gross, I'm posting here the script both for the one that creates and send mail and the one that opens Outlook and and thereby automates my sending of log files. for the one that creates and send mail: #! c:\perl\bin\perl use Win32::OLE qw(in with); use

RE: Using Outlook in Win32::OLE

2003-06-19 Thread Herold Heiko
] Sent: Thursday, June 19, 2003 4:59 AM To: Charbeneau, Chuck Cc: PERL-WIN32-USERS Subject: RE: Using Outlook in Win32::OLE Sir, I've tried the following script below and here is the result. a) the mapis32.exe process is started by the script so I am automatically authenticated (w/o

RE: Using Outlook in Win32::OLE

2003-06-19 Thread Roy Sprague
Try http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaol10/htm l/olobjApplication.asp This site has all the available methods for Outlook. The examples are in VB but they can be converted to Perl. The following code will open a list of pst files into Outlook. use Win32::OLE

RE: Using Outlook in Win32::OLE

2003-06-18 Thread Bautista, Rodel D.\(Digitel-GSM\)
- thank you very much for the one who made the script): #! c:/perl/bin/perl @attachment = ('somefile.pl'); $AttachmentArraySize = @attachment - 1; $attcount = @attachment; $sender = profile_name; $passwd = profile_password; print \n*** Automailer of Logs ***\n\n; use Win32::OLE qw(in with); use

RE: Using Outlook in Win32::OLE

2003-06-18 Thread Bautista, Rodel D.\(Digitel-GSM\)
: Thursday, June 19, 2003 8:05 AM To: Charbeneau, Chuck Cc: PERL-WIN32-USERS Subject: RE: Using Outlook in Win32::OLE Sir, again thank you very much for your help (and for everyone who shared some of their time replying to my queries and assisting in my problem). I'll try to look

RE: Win32::OLE, excel file not found

2003-06-18 Thread Allegakoen, Justin Devanandan
--8--- If you'll notice, the code provided was wrapped in % % which indicates SERVER side execution. --8--- Feel the need for a little defence on my part ;) There's no point in trying to execute server side code in the faint hope that it will open your local file. I've

RE: Using Outlook in Win32::OLE

2003-06-18 Thread Bautista, Rodel D.\(Digitel-GSM\)
is the script (taken from the pdf file of David N. Blank-Edelman posted as Perl for System Administration: Networking Power Hour - Electronic Mail): #! c:\perl\bin\perl $to=recipient_name; $subject=Test; $body=This is a test message\n; use Win32::OLE; Win32::OLE-Initialize(Win32::OLE

RE: Using Outlook in Win32::OLE

2003-06-17 Thread Charbeneau, Chuck
From: Bautista, Rodel D.(Digitel-GSM) Subject: FW: Using Outlook in Win32::OLE I'm entirely at a loss here. I'm in dire need of help with my problem below. I've tried searching for a perl script that automatically connect/log me to an outlook application and send a mail

RE: Using Outlook in Win32::OLE

2003-06-17 Thread Herold Heiko
::OLE-GetActiveObject('Outlook.Application'). Oh, and instead of $mail-CreateItem(0) generally you'll want to use use Win32::OLE::Const; $outlookconst= Win32::OLE::Const-Load(Microsoft Outlook); $mail-CreateItem($outlookconst-{olMailItem}); However the other posters point is valid. By using

RE: Win32::OLE and Excel Sorting

2003-06-12 Thread Carl Jolley
On Thu, 12 Jun 2003, Charbeneau, Chuck wrote: From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Subject: Win32::OLE and Excel Sorting heres one for u folks to get ur heads around - cos its doin mine in keeps throwing range method error in OLE The problem lies in the definition

RE: Win32::OLE

2003-06-06 Thread Ulf Lowig
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 6:07 AM Cc: [EMAIL PROTECTED] Subject: RE: Win32::OLE On 05/06/2003 11:43:41 Ulf wrote: [snip, original question about iterating over a collection] in, which does the job, was already suggested

RE: Win32::OLE

2003-06-06 Thread Steven Manross
town (or email) unexpectedly). :) Steven -Original Message- From: Ulf Lowig [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 5:03 AM To: [EMAIL PROTECTED] Cc: Steven Manross Subject: RE: Win32::OLE Thanks for pointing me to Win32::TaskScheduler. I have made some testing

Win32::OLE using Wordpad and Tk

2003-04-03 Thread James Hooker
I want to launch MS Wordpad from Perl/Tk. If I use the backtick operator to execute the Word application the main Tk window doesn't get repainted when the Wordpad program covers the main Tk window, consequently leaving huge footprints over the main Tk application. Is it possible to launch a

Re: Adding a WorkSheet to Excel using Win32::OLE

2003-03-14 Thread Carl Jolley
-Worksheets-{Count} ); $sheet = $book-{ActiveSheet}; $sheet-{Name} = $sname; but this does not work and fails with the following error: Win32::OLE(0.1601) error 0x80020009: Exception occurred in METHOD/PROPERTYGET Add at /PerlApp/Sheet.pm line 299 Can anyone help

Win32::OLE Word Search and Replace Script Runs Locally but not as part of CGI

2003-02-13 Thread Donavon Lerman
I have the same program written for Excel that works fine both locally and part of a CGI Here is the Error I get: Can't call method Content on an undefined value at c:\scripts\sr.pl line 19. Here is the Code: #!/perl/bin use strict; use Win32::OLE; use Win32::OLE

Win32::OLE 5.6?

2003-01-30 Thread FARRINGTON, RYAN
Title: Win32::OLE 5.6? has anyone seen the following error when trying to connect to a database using a connect string? the connection works for something like 50 connections then dies then comes back eventually... Any ideas? OLE exception from Provider: Unspecified error Win32::OLE

RE: Perl 5.8, Win32::OLE and exceptions

2003-01-20 Thread Jenda Krynicky
From: Steven Manross [EMAIL PROTECTED] Although I don't have 5.8 to test on, is there any chance that you playing with the Win32::OLE::Warn value might help? $Win32::OLE::Warn = 0; I set this to 0 a lot in some scripts where I expect that OLE will find an error, that I

Win32::OLE

2003-01-10 Thread FARRINGTON, RYAN
Title: Win32::OLE ok I have a script that uses Win32::OLE(ADODB.Connection) to connect to a MSSQL 2K database server and I was just playing with the query analyser provided by Microsoft with the client components. When u run a query it returns (x) rows effected [or something like that] I

RE: Win32::OLE

2003-01-10 Thread FARRINGTON, RYAN
Title: Win32::OLE the unfortunate thing about that is what happens when the row count is above 100mil [takes FOREVER =)], or your doing an update [no change] =( -Original Message-From: Bullock, Howard A. [mailto:[EMAIL PROTECTED]]Sent: Friday, January 10, 2003 3:02 PMTo

Re: Win32::OLE and Excel, Word, Access etc.

2003-01-07 Thread michael higgins
Jack wrote: I see many questions on this list asking about using Win32::OLE in interacting with these (and other MS programs). Could someone point me to either a book or online documentation which reveals all the methods one can use with each [snips] Jack -- One quick answer is there is vb

RE: Win32::OLE and Excel, Word, Access etc.

2003-01-07 Thread Beckett Richard-qswi266
I see many questions on this list asking about using Win32::OLE in interacting with these (and other MS programs). Could someone point me to either a book or online documentation which reveals all the methods one can use with each program? For example from a recent post: $excel

Re: Win32::OLE and Excel, Word, Access etc.

2003-01-07 Thread Carl Jolley
On Mon, 6 Jan 2003, Jack wrote: I see many questions on this list asking about using Win32::OLE in interacting with these (and other MS programs). Could someone point me to either a book or online documentation which reveals all the methods one can use with each program? For example from

Re: Win32::OLE and Excel, Word, Access etc.

2003-01-07 Thread Jack
- Original Message - From: Carl Jolley [EMAIL PROTECTED] To: Jack [EMAIL PROTECTED] Cc: Perl-Win32-Users [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 3:02 PM Subject: Re: Win32::OLE and Excel, Word, Access etc. On Mon, 6 Jan 2003, Jack wrote: I see many questions on this list

Re: Win32::OLE and Excel, Word, Access etc.

2003-01-07 Thread Carl Jolley
On Tue, 7 Jan 2003, Jack wrote: - Original Message - From: Carl Jolley [EMAIL PROTECTED] To: Jack [EMAIL PROTECTED] Cc: Perl-Win32-Users [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 3:02 PM Subject: Re: Win32::OLE and Excel, Word, Access etc. On Mon, 6 Jan 2003, Jack wrote

Re: Win32::OLE with Active directory question

2003-01-06 Thread Joe Richards
Win32 Users (E-mail) [EMAIL PROTECTED] Sent: Monday, January 06, 2003 8:34 AM Subject: RE: Win32::OLE with Active directory question You might want to look at the object through ADSIEdit and LDP ... I've used both many times when I'm trying to figure out what attributes are available, etc. Sean

Win32::OLE and Excel, Word, Access etc.

2003-01-06 Thread Jack
I see many questions on this list asking about using Win32::OLE in interacting with these (and other MS programs). Could someone point me to either a book or online documentation which reveals all the methods one can use with each program? For example from a recent post: $excel - {DisplayAlerts

Win32::OLE with Active directory question

2003-01-03 Thread Norris, Joseph
Everyone, I have the following code: $path = WinNT:// . Win32::DomainName(); if ( $AD = Win32::OLE-GetObject( $path ) ){; my $Schema = Win32::OLE-GetObject( $AD-{Schema} ); if( $Schema-{Container} ) { $AD-{Filter} = f=user

Re: Win32::OLE writing to excel.

2002-12-14 Thread Steve
I'm having a horrendous time trying to write to cells in my spreadsheet that are specified by variables. I'm trying to write like this: $active_sheet - Cells ($set, ($loop + 24)) - {Value} = ($loop); $active_sheet - Cells (($set + 1), ($loop + 24)) - {Value} = (some text); The Value

Re: relative path in Win32::OLE

2002-11-27 Thread Carl Jolley
On Wed, 27 Nov 2002, Wang Yuki-R59273 wrote: Hello all, I don't know why i cannot use relative path is Win32:OLE like this: my $Book = $Excel-Workbooks-Open(..\\test.xls); I only can make it work with abosolute path like this: my $Book = $Excel-Workbooks-Open(d:\\test.xls); can anyone

Unexpected Win32::OLE error on closing an Excel Workbook

2002-11-15 Thread Brian W Smith
Fellow Users, I have a script which uses Win32::OLE and Win32::OLE::Variant to open an existing Excel workbook, select a particular worksheet, read it and then close the workbook. The following snippet illustrates this: use MyStuff; # home made package

RE: Unexpected Win32::OLE error on closing an Excel Workbook

2002-11-15 Thread Bro Ji, Ing. 11030
Brian W Smith wrote: Fellow Users, I have a script which uses Win32::OLE and Win32::OLE::Variant to open an existing Excel workbook, select a particular worksheet, read it and then close the workbook. The following snippet illustrates this: use MyStuff; # home made

win32::ole format ?

2002-11-11 Thread lance
I am trying to format an Excel cell. Everything works but the HorizontalAlignment. VBA Macro gives: Range("D3").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .ShrinkToFit = False .MergeCells =

RE: Downloading Files VIA Win32::OLE and IE.5

2002-11-02 Thread Bro Ji, Ing. 11030
Title: Downloading Files VIA Win32::OLE and IE.5 You maybe will  find helpful contents of this file : http://web.telecom.cz/cmincmin/OLE-XMLHTTP.zip (WinZip file, size: 1,691,192 bytes, Digest::MD5::hexdigest: d41d8cd98f00b204e9800998ecf8427e) A bit of  relevat original Microsoft

RE: Win32::OLE=HASH lastLogon ADSTYPE_LARGE_INTEGER

2002-10-21 Thread Tillman, James
-Original Message- From: Livingston, Rex [mailto:Rex.Livingston;praxa.com.au] Sent: Friday, October 18, 2002 11:06 PM To: Tillman, James; Perl Win32 Users (E-mail) Subject: RE: Win32::OLE=HASH lastLogon ADSTYPE_LARGE_INTEGER Thanks James...this code now works and may be useful

Win32::OLE=HASH lastLogon ADSTYPE_LARGE_INTEGER

2002-10-18 Thread Livingston, Rex
value from Perl ? Sample code: use Win32::OLE qw(in); use Win32::OLE::Enum; use Win32::OLE::Variant; $adspath = LDAP://CN=Lastname\\, Firstname . ,OU=Users,OU=City,DC=companyname,DC=com,DC=au; $rs = Win32::OLE-GetObject($adspath); foreach $f ('AdsPath','whenCreated','lastLogon

RE: Win32::OLE=HASH lastLogon ADSTYPE_LARGE_INTEGER

2002-10-18 Thread Tillman, James
%40tkmsftngp04rnum=4 It looks as if that Win32::OLE object you're getting back just might have a couple of useful properties, one called HighPart, and one called LowPart, upon which you might be able to do some math, but that's a guess since I don't know VB.NET at all. Presumably, once you get the long integer

Win32::OLE question and outlook

2002-10-08 Thread smackdab smackdab
Hi, I have gotten *somewhat* good at using this for outlook... I can get many MailItem functions to work: reply, move, delete, etc. But Forward doesn't. This is the error I get: Usage: Win32::OLE::Forward(self, method) at test.pl line 273.\n This works my $newmsg = $origmsg-Reply

RE: Win32::OLE accessing outlook subfolders

2002-09-27 Thread Mark Sutfin
On Tuesday, 09/24/2002, Martin Bower wrote: :Hi, :The script below will access Outlook 98, and give me a list of items in my :Inbox. I would like to ammend this so I can see what sub-folders I have :below Inbox, and scroll through their contents as well. :Can anyone point me in the right

RE: Win32::OLE accessing outlook subfolders

2002-09-27 Thread Norris, Joseph
]' Subject: RE: Win32::OLE accessing outlook subfolders On Tuesday, 09/24/2002, Martin Bower wrote: :Hi, :The script below will access Outlook 98, and give me a list of items in my :Inbox. I would like to ammend this so I can see what sub-folders I have :below Inbox, and scroll through

RE: Win32::OLE accessing outlook subfolders

2002-09-27 Thread Tillman, James
]] Sent: Friday, September 27, 2002 12:00 PM To: 'Mark Sutfin'; 'Martin Bower'; '[EMAIL PROTECTED]' Subject: RE: Win32::OLE accessing outlook subfolders Mark, My experments with this have been - ah - painful (yes that's the right word). On problem I have with any of this is that whenever I

Re: Calling WMI Methods with Win32::OLE

2002-09-26 Thread Thomas R Wyant_III
unless the call returns TRUE. use Win32::OLE qw{in with}; use Win32::OLE::Const 'WMI'; # If needed use Win32::OLE::Variant; # If needed my $mach = shift @ARGV || .;# Or whoever my $olecls = winmgmts:{impersonationLevel=impersonate,(Debug)}!//$mach/root/cimv2; my $wmi = Win32::OLE

RE: Calling WMI Methods with Win32::OLE

2002-09-26 Thread Gibb, Thomas A
, September 26, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: Calling WMI Methods with Win32::OLE I have looked everywhere to find an example of how to call a "method" in WMI with perl, and have been unsuccessful. Does anyone know if it can be done, and if so, have an example? F

Re: Win32::OLE MS Word

2002-09-17 Thread work
This will insert text at the beginning of a document. use strict; use warnings; use Win32::OLE; my $oWord = new Win32::OLE(Word.Application); my $clBlue = 16711680; my $clGreen = 32768; my $oDoc = $oWord-Documents-Add(); $oWord-Selection-TypeParagraph; $oWord-Selection-Font-{Size} = 14

[OLE] Win32::OLE source

2002-09-12 Thread Tom Allebrandi
Hi! Is the source for the XS part of Win32::OLE available anywhere? I'm working on a COM/OLE project and I'd like to study the XS side of Win32::OLE to see how some things are supposed to be done. Thanks! --- tom tom allebrandi [EMAIL PROTECTED

Re: [OLE] Win32::OLE source

2002-09-12 Thread Jan Dubois
On Thu, 12 Sep 2002 13:53:54 -0400, Tom Allebrandi [EMAIL PROTECTED] wrote: Is the source for the XS part of Win32::OLE available anywhere? I'm working on a COM/OLE project and I'd like to study the XS side of Win32::OLE to see how some things are supposed to be done. Yes, the latest version

Issues with Win32-OLE

2002-08-30 Thread mjg
There seems to be underlying issues with Win32-OLE I would like explained. First, I use Perl Build 630. Win32-OLE version 1403. Before I send examples, is there a compatiility conlit with these? Even the simplest programs fail. Thanks

Hard coded replacement for Win32::OLE::Variant VT_BOOL?

2002-08-28 Thread Steve Combs
How can I hard code a variant boolean True or False without using Win32::OLE::Variant? I use Perl quite a bit under ASP where the default scripting language is VBScript. :( In many cases, I'll want to set a flag in a session variable or return a boolean value. Rather than calling in all

Win32::OLE and Visible property

2002-08-18 Thread Andre Warnier
of code. my $WordFile = $doc_path\\ . $file; my $Doc = Win32::OLE-GetObject($WordFile) || die Failed to open FTPd document\n; my $Word = $Doc-{Application}; $Word-{Visible} = 0; my $Merge = $Doc-MailMerge; my $datasrc = ($datasrc_path\\datasrc.xls); $Merge-{MainDocumentType} = wdFormLetters

Re: Win32::OLE and Visible property

2002-08-18 Thread Mark Veerman
? thanks for your help!! /mark I believe if you use the following right after the use WIN32::OLE, you may get a more explanatory error message of why it fails. Win32::OLE-Option(Warn=2); André Warnier EIS LP [EMAIL PROTECTED] Hello, I'm trying to create automation with Word with the Visible

Re: Win32::OLE and Visible property

2002-08-18 Thread Carl Jolley
? Or am I missing something that should be obvious? thanks for your help!! /mark I believe if you use the following right after the use WIN32::OLE, you may get a more explanatory error message of why it fails. Win32::OLE-Option(Warn=2); André Warnier EIS LP [EMAIL PROTECTED] Hello

Win32::OLE and Visible property

2002-08-17 Thread Mark Veerman
\\ . $file; my $Doc = Win32::OLE-GetObject($WordFile) || die Failed to open FTPd document\n; my $Word = $Doc-{Application}; $Word-{Visible} = 0; my $Merge = $Doc-MailMerge; my $datasrc = ($datasrc_path\\datasrc.xls); $Merge-{MainDocumentType} = wdFormLetters; $Merge-OpenDataSource($datasrc,{Connection

Win32::OLE::Variant

2002-08-09 Thread Briggs, Larry
Hi I have just up graded to the latest version of active perl and learned that I needed to add Variant on the end of Win32::OLE. To be able to pull dates correctly. I am still having a problem when I check if a date is less than the current date it is going into the if statement even when

RE: Win32::OLE::Variant

2002-08-09 Thread Briggs, Larry
build 633. I have only up graded one machine and from testing I learned that I need to add the use Win32::OLE::Variant where we did not have to have that with the older version. Is there something else that I need to do so that the existing code will still work? Thanks Larry -Original Message

Re: Win32::OLE: Language of error message?

2002-07-31 Thread Sisyphus
- Original Message - From: Dr. Thomas Bruns [EMAIL PROTECTED] Win32::OLE(0.1502) error 0x80020010: Aufgerufener ist ungAültig in METHOD/PROPERTYGET myMethod at myModule.pm line 123 I am German, but this messages makes no sense to me! So, I'd rather like this messages

Re: Passing a GUID to Win32::OLE

2002-07-15 Thread Jan Dubois
On Sun, 14 Jul 2002 15:56:07 +0100, [EMAIL PROTECTED] wrote: Anybody know a way to call a method which takes a REFCLSID, like this: HRESULT foo( REFCLSID bar ); The OLE browser shows this as Sub foo( bar as GUID ) method foo; Unfortunately, Win32::GuidGen seems to return a GUID in

OLE: win32::ole::const error ( emptyenum redefined )

2002-06-11 Thread mathias wündisch
Hy, does anybody know, what this error message mean (... emptyenum redefined...) ? ( without 'use diagnostics' no error message ) thanks! mathias = perl -e use strict; use diagnostics;use Win32::OLE;use Win32::OLE::Const ('Microsoft Word'); exit Constant

Win32::OLE help

2002-06-06 Thread parvez
Hi Perl Gurus I'm facing a problem. I'm using Win32::OLE and my code goes something like this some code here Win32::OLE-Option(Warn = sub {goto CheckError}); ## some other code here for(;;) { ### more boring lines of code in between here CheckError: { print LOG

<    1   2   3   4   5   >