Re: Fwd: Win32::OLE merge rtf files - table structure missing

Hi Mike, Gratitude for coming forward to refine the solution. Please find the attached file which is considered as the source file where I am trying to extract the 2D measurements data and format those results in a table and would like to keep them inside the "comments:" section at the bottom of t

Re: Fwd: Win32::OLE merge rtf files - table structure missing

Thank you.  I received a small file: "source.rtf" and a larger 1.9 MB file: "source.RTF". "source.RTF" has a table and graphic graphs - 2 pages total. "source.rtf" is just 2 pages of ASCII text, with an ASCII table: ┌┬───┬───┬─┬ │ Fetal_Biomet

Re: Win32::OLE merge rtf files - table structure missing

Trying to upload the source file content here... *Clinical Indications & Data* *LMP: *25/01/2022*GA: *14w1d*EDD(LMP): *01/11/2022*AUA: *14w0d* EDD(AUA): *02/11/2022*Gestations: *1 *Obstetrics-Page * *2D Measurements* *BPD* *Hadlock* *2.44cm* *35.57%*

Fwd: Win32::OLE merge rtf files - table structure missing

Subject: Re: Win32::OLE merge rtf files - table structure missing To: Cc: There are a bunch of steps there. When you say "construct a table" - in what format? Is the finished product an html file? Do you know how to parse the rtf file already? If not, send an rtf file to me at te...

Re: Win32::OLE merge rtf files - table structure missing

There are a bunch of steps there. When you say "construct a table" - in what format? Is the finished product an html file? Do you know how to parse the rtf file already? If not, send an rtf file to me at te...@mflan.com I have attached a file to see if the list accepts attachments. Mike O

Win32::OLE merge rtf files - table structure missing

nts/suggestions will be much appreciated.Thanks. #! C:\Strawberry\perl\bin use strict; use Win32::OLE; use Win32::OLE::Const; use File::Spec::Functions 'canonpath'; #use Data::Dumper; use File::Basename; use Cwd 'abs_path'; use utf8; use Encode; Win32::OLE->Option (CP =>

help on pie chart color -- Win32::OLE

king fine. But, now the requirent is that there should should not be any extra excel file in addition to the xlsx where the pie chart is. So, I have to change the colors from my perl script only. So, I have written the following code . use Win32::OLE::Variant ; use Win32::OLE qw(in with) ; use Win32:

RE: Perl script on a server using Win32::OLE

Thanks. F: is the local drive on the server. Now I schedule the script to be run on a daily base instead of calling from my local machine. So far it is OK. Thanks anyway. Cheers, Jason > Date: Wed, 3 Oct 2012 19:34:45 +0200 > Subject: Re: Perl script on a server using Win32::OLE

Re: Perl script on a server using Win32::OLE

On Wed, Sep 26, 2012 at 8:23 AM, Jason Feng wrote: > > Hello, > > I have a Perl script running on a Windows 2008 server which uses Win32::OLE > to dump the results on Excel files. It is working fine when I remote login to > the server and run the script. > > Now I want t

Perl script on a server using Win32::OLE

Hello, I have a Perl script running on a Windows 2008 server which uses Win32::OLE to dump the results on Excel files. It is working fine when I remote login to the server and run the script. Now I want to write a Perl script on my local machine using Net::Telnet to remote run the script on

Re: My first perl program after 6 years (need help on Win32::OLE ADSI script)

Hi Andrew, On Thu, Sep 6, 2012 at 5:23 AM, andrew sison wrote: > I've done some reading and learned that in order to automate that > particular task using perl, I would have to use either Win32::OLE or > Net::LDAP. So I decided to use to former. Actually, I would strongly recom

Re: My first perl program after 6 years (need help on Win32::OLE ADSI script)

Hi Andrew, I'm not an OLE or Win32::OLE expert, but see below for a review of your code: On Thu, 6 Sep 2012 11:23:41 +0800 andrew sison wrote: > Hello, > > It has been six years since I have shifted into a new role from being > a systems administrator to being an IT auditor.

My first perl program after 6 years (need help on Win32::OLE ADSI script)

the information stored in our active directory. I've done some reading and learned that in order to automate that particular task using perl, I would have to use either Win32::OLE or Net::LDAP. So I decided to use to former. Now I am confronted with this simple problem which one would conside

Re: win32::OLE helpppp

On Jun 6, 2012, at 1:54 PM, Ken Furff wrote: > apparently win32::OLE can be used to write to an existing spreadsheet. I have > read the cpan docs and tried a hundred things, but I cant seem to get the > syntax right. Win32::OLE doesn't write spreadsheets, but it does try to con

win32::OLE helpppp

apparently win32::OLE can be used to write to an existing spreadsheet. I have read the cpan docs and tried a hundred things, but I cant seem to get the syntax right. I'm going to post this script one more time. #!/usr/bin/perl use strict; use Spreadsheet::XLSX; use File::Copy; use Win32

Re: Create, Merge and work with tables in MS WOrd Documents Win32::Ole

: > Hi... > > I have this code > > use Win32::OLE; > my ($t_row, $t_col) = (4,3); > my $word = Win32::OLE->CreateObject("Word.Application"); > $word->{Visible} = 1; > my $doc = $word->Documents->Add; > my $table = $doc->Tables->Add($word->S

Re: Create, Merge and work with tables in MS WOrd Documents Win32::Ole

the module installed on your system in your browser. * - Timothy Adigun* * * to install the module Pod::Webserver, issue the following command on your CLI cpan Pod::Webserver On Fri, Apr 13, 2012 at 4:14 AM, Raito Garcia wrote: > Hi... > > I have this code > > use Win32::OLE; >

Create, Merge and work with tables in MS WOrd Documents Win32::Ole

Hi... I have this code use Win32::OLE; my ($t_row, $t_col) = (4,3); my $word = Win32::OLE->CreateObject("Word.Application"); $word->{Visible} = 1; my $doc = $word->Documents->Add; my $table = $doc->Tables->Add($word->Selection->Range,$t_row, $t_col); $t

Win32::Ole and Powerpoint

I have been working on a script that imports a number of pictures into powerpoint edits some text and saves the presentation out. The main program works fine but there are some annoying things that happen with the application. I am creating the application with: my $app = Win32::OLE->

Re: WIN32:OLE module

On Thu, Apr 2, 2009 at 06:53, Irfan Sayed wrote: snip >> http://search.cpan.org/search?query=Inline::C&mode=module >> http://search.cpan.org/search?query=FFI&mode=module snip > sorry i did not get. could you please explain once again snip Inline::C is a module that allows you to easily write and

Re: WIN32:OLE module

sorry i did not get. could you please explain once again regards jaya From: Jenda Krynicky To: Irfan Sayed Sent: Thursday, April 2, 2009 3:36:57 PM Subject: Re: WIN32:OLE module Date sent:    Thu, 2 Apr 2009 02:07:08 -0700 (PDT) From:    Irfan Sayed

Re: WIN32:OLE module

rom: Jenda Krynicky To: beginners@perl.org Sent: Thursday, April 2, 2009 4:32:13 AM Subject: Re: WIN32:OLE module From: Irfan Sayed > > I have one perl script in which i am using win32:OLE perl module. Now > i need to convert script so that it can support solaris OS also. can > it be possib

Re: WIN32:OLE module

From: Irfan Sayed > > I have one perl script in which i am using win32:OLE perl module. Now > i need to convert script so that it can support solaris OS also. can > it be possible?? > if yes what is the equivalant module of win32:OLE on unix or any other option. I would guess yo

Re: WIN32:OLE module

WIN32:OLE module > Hi All, > > I have one perl script in which i am using win32:OLE perl module. Now i need > to convert script so that it can support solaris OS also. can it be possible?? > if yes what is the equivalant module of win32:OLE on unix or any other option. > I do

RE: WIN32:OLE module

> Hi All, > > I have one perl script in which i am using win32:OLE perl module. Now i need > to convert script so that it can support solaris OS also. can it be possible?? > if yes what is the equivalant module of win32:OLE on unix or any other option. > I don't think

Re: WIN32:OLE module

Please please help/advice Jaya From: Irfan Sayed To: beginners@perl.org Sent: Wednesday, April 1, 2009 4:48:15 PM Subject: WIN32:OLE module Hi All, I have one perl script in which i am using win32:OLE perl module. Now i need to convert script so that it

WIN32:OLE module

Hi All, I have one perl script in which i am using win32:OLE perl module. Now i need to convert script so that it can support solaris OS also. can it be possible?? if yes what is the equivalant module of win32:OLE on unix or any other option. Please advice. Jaya

Re: Win32::OLE help for saving file.

On Sep 13, 4:21 pm, [EMAIL PROTECTED] (Ash) wrote: > Hello fellow scripters!! > > What stumps me is pretty straight forward. I need to save a Word file > using Win32::OLE, but I need to replace an existing file if there is > any. > What properties do I have to set before call

Win32::OLE help for saving file.

Hello fellow scripters!! What stumps me is pretty straight forward. I need to save a Word file using Win32::OLE, but I need to replace an existing file if there is any. What properties do I have to set before calling SaveAs() to do that? Any help is appreciated. Thank you very much. -- To

Re: Win32::OLE - MSDEV

From: "bao song" <[EMAIL PROTECTED]> > Hi all, > i am trying to wirte a script for automating visual C++ builds, i checked > both the OLE/COM Object Viewer and OLE Browser, seemed that there is no such > entry. Of course, followed the general pattern as:

Win32::OLE - MSDEV

Hi all, i am trying to wirte a script for automating visual C++ builds, i checked both the OLE/COM Object Viewer and OLE Browser, seemed that there is no such entry. Of course, followed the general pattern as: eval {$app = Win32::OLE->GetActiveObject('MSDev.Application')}; d

Re: processing XL using Win32::OLE

Found a good tutorial here : http://www.perlmonks.org/?node=153486 - Original Message From: alok nath <[EMAIL PROTECTED]> To: beginners@perl.org Sent: Friday, June 29, 2007 10:42:56 AM Subject: processing XL using Win32::OLE Hi, Can anybody tell how to open an already existing x

Re: processing XL using Win32::OLE

Hi Alok, Hope the examples in the below links help your needs. For opening and reading an XL(Excel) use strict; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3;# die on errors... # get already ac

processing XL using Win32::OLE

Hi, Can anybody tell how to open an already existing xL file and then probabaly do some processing using Win32::OLE I found quite a few examples but none of them open an existing excel file. Or is there some better module for XL processing ? Here is my code .. use strict ; use warnings

Re: Win32::OLE packages

Eventually, I figured it out. use strict; use warnings; use Win32::OLE; my $Excel = Win32::OLE->new('Excel.Application'); my $WorkBook = $Excel->Workbooks->Add; my $freeze_panes = $WorkBook->ActiveSheet->Range("B3")->Select; $Excel->ActiveWindow->{Fr

Re: Win32::OLE packages

Hi to all, Sorry for asking the same question.. I beleave sombody have used win32:OLE module. From the Module description: OLE Automation brings VisualBasic like scripting capabilities and offers powerful extensibility and the ability to control many Win32 applications from Perl scripts

Win32::OLE packages

Hello All, Does anybody know which package in Win32:OLE will Freeze Panes and call Format Report method in excel document? Thanks in advance, Vladimir

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

Monday, October 10, 2005 2:25 PM To: [EMAIL PROTECTED] 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 S

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 server. I used the following code as a guide: http://msdn.microsoft.com/library/en-us/dnsqlmag2k/html/adoxmlListing_02.txt If I create a VB project

RE: help required regarding Win32::OLE

> -Original Message- > From: a b [mailto:[EMAIL PROTECTED] > Sent: Thursday, 9 February 2006 11:47 PM > To: libwin32@perl.org; beginners@perl.org > Subject: help required regarding Win32::OLE > > > Hello all perl gurus, > > i'm sticking out with the

help required regarding Win32::OLE

Hello all perl gurus, i'm sticking out with the issue of changing configuration of IIS server running on remote machine. i want to know the possibility of doing that using Win32::OLE module. so, far i am unable to do that. Can any body send me some tutorials / docs regarding IIS s

Re: WIN32::OLE problem while reading the date format

See Win32::OLE::Variant on ActiveState Perl Documentation on how to read the date correctly. Alfred, swayam panda wrote: Hi ALL, I am reading some values from the Excel file by using Win32::OLE,I am able to read all fields bur not able able read if the date is in dd/mm/yy( i.e

WIN32::OLE problem while reading the date format

Hi ALL, I am reading some values from the Excel file by using Win32::OLE,I am able to read all fields bur not able able read if the date is in dd/mm/yy( i.e / slash) .If i am using backward slash then the date is working .Can any body tell me how to read the a date from the EXCEL

Win32::OLE for IIS

> > Hello all, > > I have one require to modify the properties of IIS runing on remote > machine. > i tried it with Win32::OLE module but unsuccessful > > my code :- > > use strict; > use Win32::OLE; > use Win32::OLE::Enum; > > Win32::OLE->Option(Warn =

Win32::OLE for IIS

Hello all, I have one require to modify the properties of IIS runing on remote machine. i tried it with Win32::OLE module but unsuccessful my code :- use strict; use Win32::OLE; use Win32::OLE::Enum; Win32::OLE->Option(Warn => 3); my $hostname = 'myremotehost'; my $rootkey ;

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

Monday, October 10, 2005 2:25 PM To: perl-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 XM

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 server. I used the following code as a guide: http://msdn.microsoft.com/library/en-us/dnsqlmag2k/html/adoxmlListing_02.txt If I create a VB project

RE: Win32::OLE question(s)

You should be able to use the Win32::OLE::Variant module to extract the date. Do a 'perldoc Win32::OLE::Variant' and check out the Date() method. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 2:13 PM To: beginners@perl.org Subject:

RE: Win32::OLE question(s)

ks. >> Tim > > Read up on the Range property and Cells property. > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl11 > /html/xlproCells1_HV03076630.asp > > use strict; > use Win32::OLE qw/in with/; > > my $Excel = Win32::OLE->GetA

RE: Win32::OLE question(s)

operty. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl11 /html/xlproCells1_HV03076630.asp use strict; use Win32::OLE qw/in with/; my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application', 'Quit&#

Win32::OLE question(s)

Hello. The following code produces the output below. The first column should be a date. This happens whether the "valof" function is used or not. Anyone have any Variant tricks? Thanks. Tim my $Excel = Win32::OLE->GetActiveObject('Excel.Application')

Re: A question about Win32:OLE

nal Message- > From: J aperlh [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 01, 2005 9:08 PM > To: Siegfried Heintze > Cc: beginners@perl.org > Subject: Re: A question about Win32:OLE > > Thanks for your help. > > I can find it in regedit. > > I have to find i

Difference between Win32::API and Win32::OLE.

Difference between Win32::API and Win32::OLE. As I know, Win32::API can import and call functions from Win32's Dynamic Link Libraries (DLL), I was wondering if it can import and call functions from standalone executables, just like Win32:OLE does. I tried Win32::OLE to call serveral funtio

A question about Win32::OLE. Really need you help!!!

A question about Win32::OLE. Really need you help!!! There is a standalone executable written in C/C++. What I am going to do is to write a perl script to call several functions available in this executable. >From the following article, I thought the job is very easy. #10 - Win32::

RE: A question about Win32:OLE

search. S -Original Message- From: J aperlh [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 01, 2005 9:08 PM To: Siegfried Heintze Cc: beginners@perl.org Subject: Re: A question about Win32:OLE Thanks for your help. I can find it in regedit. I have to find it out in OLE/COM Object

Re: A question about Win32:OLE

: if your application is working, why do > you care if you can find it in OLE/COM viewer? > > Re. shutdown: Check the documentation for Win32::OLE -- I remember there is > a way to shut down an application. > > Now beware the some applications, like Microsoft Word, don't

RE: A question about Win32:OLE

d it in OLE/COM viewer? Re. shutdown: Check the documentation for Win32::OLE -- I remember there is a way to shut down an application. Now beware the some applications, like Microsoft Word, don't follow the rules. You can observer this by creating an instance of Microsoft word and $app->

It seems that Win32::OLE::Variant doesn't work!

It seems that Win32::OLE::Variant doesn't work! Below is the script: #! perl -W use strict; use Win32::OLE; use Win32::OLE::Variant; my $Array = Variant(VT_ARRAY|VT_R8, [1,2], 2); $Array->Put([[1,2], [3,4]]);

Re: A question about Win32:OLE

Thanks for your help! I have a application installed on my system. I can start the application by using: my $app = Win32::OLE->GetActiveObject('Aaa.Bbb'); The problem is that I cannot find Aaa.Bbb in OLE/COM Object Viewer or OLE-Browser. I did a thorough search! Another que

RE: A question about Win32:OLE

-Original Message- From: J aperlh [mailto:[EMAIL PROTECTED] Sent: Sunday, May 29, 2005 8:10 PM To: beginners@perl.org Subject: A question about Win32:OLE A question about Win32:OLE! Where can I get the program ID of an application? Get it from OLE/COM Object Viewer or something else? my $app

A question about Win32:OLE

A question about Win32:OLE! Where can I get the program ID of an application? Get it from OLE/COM Object Viewer or something else? my $app = Win32::OLE->new('Word.Application', 'Quit'); ! -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

A question about Win32:OLE!

Where can I get the program ID of an application? Get it from OLE/COM Object Viewer or something else? my $app = Win32::OLE->new('Word.Application', 'Quit'); -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <htt

Re: Word Automation through Win32::OLE

Jonathan and Jenda, I appreciate you taking the time to run through the basics. I'll make sure to use strict and warnings from now on. I sure hope it saves the time you are suggesting. Sometimes the debugging drives me nuts. The difference between properties and methods is difficult to determine

Re: Word Automation through Win32::OLE

From: Jonathan Paton <[EMAIL PROTECTED]> > > print "$fileName\n"; > > $doc->ActiveDocument->SaveAs({FileName => $fileName, > > FileFormat => wdFormatRTF}) > > 'Can't call method "SaveAs" on an undefined value'. > > That clearly means that "$doc->ActiveDocument" evaluates

Re: Word Automation through Win32::OLE

Dear Mark, > Long time lurker, first time poster...please be gentle. Shame you missed the many comments on strict and warnings. Consider these mandatory whilst learning: use strict; use warnings; I am not familar with Win32::OLE, but there is certainly some errors in your code I can show

Word Automation through Win32::OLE

but I thought just being able to save was a good place to start. Currently I get an error stating 'Can't call method "SaveAs" on an undefined value'. If someone could point me to some clearer text on Win32::OLE than the stuff that ASPN, CPAN and Oreilly's Win32 or Nu

Word Automation through Win32::OLE

but I thought just being able to save was a good place to start. Currently I get an error stating 'Can't call method "SaveAs" on an undefined value'. If someone could point me to some clearer text on Win32::OLE than the stuff that ASPN, CPAN and Oreilly's Win32 or Nu

Win32::OLE Word Macro Conversion

aceTextFromSpellingChecker = True .CorrectKeyboardSetting = False .DisplayAutoCorrectOptions = True .CorrectTableCells = True End With With Options .LabelSmartTags = False .DisplaySmartTagButtons = True End With End Sub ###SCRIPT #!C:\Perl\bin\perl5.8.4

Perl and win32::ole

Hi. I would like to copy and then paste multiple times some lines of text from .doc file to some other location and I wonder if someone has some piece of example code? Best regards, Rok -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: Win32::OLE 7 Excel

Hello, At the bottom is my is my entire code. Ofcourse all it does is get data out of a Lotus Notes server and dump it into excel. If you see the last lines I want to change the column width of a column in Excel. and that doesn't happen! Regards Saadat Saeed use strict; use Win32

RE: Win32::OLE 7 Excel

Saadat Saeed <[EMAIL PROTECTED]> wrote: : : Now it gives me an error :-( : : syntax error at mailrep.pl line 52, near ");" : Execution of mailrep.pl aborted due to compilation : errors. Please stop top-posting! If you post a little more code, we can show you how to properly use a while

Re: Win32::OLE 7 Excel

my $r = $Sheet->Columns($Range), ColumnWidth > => 1); > > > > > > > Saadat Saeed <[EMAIL PROTECTED]> > 03/11/2004 11:55 AM > > To > [EMAIL PROTECTED] > cc > > Subject > Win32::OLE 7 Excel > > > > > > > Now Using Win32::OLE I co

Re: Win32::OLE 7 Excel

change 'with' -> 'while' while (my $r = $Sheet->Columns($Range), ColumnWidth => 1); Saadat Saeed <[EMAIL PROTECTED]> 03/11/2004 11:55 AM To [EMAIL PROTECTED] cc Subject Win32::OLE 7 Excel Now Using Win32::OLE I could input Data into an

Win32::OLE 7 Excel

Now Using Win32::OLE I could input Data into an Excel sheet using the perl docs by ActiveState. However now I also want to format Here is my code snippet $Range = $Sheet->Range("E1"); with (my $r = $Sheet->Columns($Range), ColumnWidth => 1); Very simple eh? Any reas

Win32::OLE, Read Fix Length Text, Loop Problems

- Original Message - From: "William Martell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, December 22, 2003 10:26 AM Subject: Read Fix Length Text, Loop Problems > Hello All, > > Thanks for reading my email. I am trying to read a fix length text file an

Fw: Win32::OLE, Simple Question

- Original Message - From: "William Martell" <[EMAIL PROTECTED]> To: "perl-win32-users" <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 11:24 AM Subject: Win32::OLE, Simple Question > Hello All, > > Could anyone help me with this script.

Re: Win32::OLE

From: "Shishir K. Singh" <[EMAIL PROTECTED]> > I am trying to run simple script that tries to parse an XLS file. The > script name is x.pl and the xls file that it tries to open is x.xls > and they both exist in the same directory. Always use absolute paths with OLE. The working directory of the

Win32::OLE

# use strict; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3; my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application', 'Quit'); my $Book = $Excel->Workbooks-&

win32::ole - Excel - Can't call method "Worksheets"

lt. armonth.xls is in the same folder as the script. What is really bizarre is the script worked Friday when I left. . The file still exists and the spelling is correct. Any ideas? Code - my $excelfile = 'armonth.xls'; use Win32::OLE qw(in with); use Win32::OLE::Const 'M

Re: perl EXCEL app/Win32::OLE

\\" and not "/". > > Since you are using Microsoft's Excel Engine, the > Excel APIs are very strict about the path syntax and > therefore, Perl's separatorChar of "/" (forward > slash) will not work! > > Cheers, > Rex > > - Original M

Re: perl EXCEL app/Win32::OLE

rk! Cheers, Rex - Original Message - From: M z To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 9:24 PM Subject: perl EXCEL app/Win32::OLE Dear all, i have a simple and silly question really..I downloaded this from the web, tried it, checked several times to ens

perl EXCEL app/Win32::OLE

I do have Win32:OLE installed, as it came with my 5.6 build thanks I keep getting the following error OLE exception from "Microsoft Excel" 'test.xls' could not be found. Win32::OLE(0.1502) error (x800a03ec in method/propertyget "Open" at test.txt line 14 Pl

RE: Win32:OLE and Excel, problems writing from the web

= "OK"; $Sheet->PageSetup->{FirstPageNumber} = xlAutomatic; $Sheet->PageSetup->{PrintTitleRows} = "1:1"; -Original Message- From: Murphy, Land [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:34 PM To: '[EMAIL PROTECTED]' Subject: RE

RE: Win32:OLE and Excel, problems writing from the web

GI qw(:standard :netscape); use DBI; use Win32::OLE qw(in valof with); use Win32::OLE::Const 'Microsoft Excel'; $date = '2002/04/01'; %attr = (PrintError => 0,RaiseError => 0); $database='dbi:mysql:database=helpdesk:host=192.168.212.30'; $user='root'; $pas

Win32:OLE and Excel, problems writing from the web

replace an IBI product called WebFocus. Any ideas appreciated. Even with the code that does work. I'll be the first to admit I'm a novice and a hack. Thanks, Land #Script Below## use CGI qw(:standard :netscape); use DBI; use Win32::OLE qw(in valof with); use Win

Re: Win32::OLE, or maybe POP3Client Module??

Try Mail::POP3Client module, available from the PPM Repository of Activestate. - Rex - Original Message - From: "Chris Zampese" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 23, 2002 10:49 PM Subject: Win32::OLE, or maybe POP3Client Modul

Win32::OLE, or maybe POP3Client Module??

Hello everyone! I am still trying to read the subject line of all messages in my Outlook Express Inbox. I know that this is possible using VB SCript - microsoft provides comprehensive tutorials in their suppport pages, but I cannot seem to get it to run in Perl. I thought that maybe it w

RE: Win32::OLE and Excel questions

There isn't any docs with Win32::OLE for a good reason... the methods/properties depend on the OLE/COM object you are using. I suggest poking around Microsoft's site to see if there is any documentation on their objects, or use the OLE browser that comes with the ActivePerl docs (look

Win32::OLE and Excel questions

I can't seem to find any real documentation on getting the Excel parsing stuff to work like I expect. Here is my script--copied and modified from an example. I've looked throught the win32::ole module and can't find any serious documentation on things like -- my $date = $Sh

RE: Win32::OLE SaveAs functions problem

I haven't worked with the OLE modules at all but I'll put in my 2 cents. It's not clear to me that $filename is open from this snippet. It looks like $filename gets defined and then you delete it if it's there and is a regular file. I don't know what the SaveAs method does but I'm guessing it sa

Win32::OLE SaveAs functions problem

Hi, I tried a lttle bit to get used to Win32::OLE And also searched tutorials on the Web. I found an interesting one, but at this part in the code I get stuck... --- CODE //some sutff $filename = 'd:\apache\apache\cgi-bin\perl2.xls'; unlink $filename if -f $filename;