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::OLE

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 reason why it would not work

Re: Win32::OLE 7 Excel

Now it gives me an error :-( syntax error at mailrep.pl line 52, near ); Execution of mailrep.pl aborted due to compilation errors. --- Hari Fajri [EMAIL PROTECTED] wrote: change 'with' - 'while' while (my $r = $Sheet-Columns($Range), ColumnWidth = 1); Saadat Saeed [EMAIL

Conditional formatting in Excel

Okay - why doesn't conditional formatting work? Are my OLE statements correct - or is this more of an Excel issue??? (Over here I am extracting some data from Lotus Notes and dumping it into Excel --- all works fine except for the conditional formatting) use strict; use Win32::OLE; my $fp; my

WinNT perl scripts - adding modules on all machines

Just a question or doubt I had. Now using activestate's activeperl if I deploy it on all machines on my network. And I have certain scripts for those machines. If I release a new script that depends on a perl module not on the activeperl distribution by default how can I distrubute the

netadmin change password

Hello, I have been reading about the change password function in NetAdmin (Win32). Now it says I need to input the old password. What is I am in the domain admin group and I do not know the old password. Any thingy in perl that'll help me change local computer user accounts without needed to know

Sub not working as it should

#!C:/Perl/bin/perl.exe #use IO::File; $file = comp.lst; $new = ee.lst; open (FH, $file) or die Cannot open file $file $!; open(NEW, $new) or die can't open $new: $!; while($line = FH) { chomp $line; opendir(DIR,$line\\c\$\\Docume~12) or errornos($line,1,NEW);

Re: Re: Sub not working as it should

Thanks for the quick reponse - looks like I confuse my vbscript skills a bit... I am new to perl and am migrating over to vbscript! Regards --- Jeff 'japhy' Pinyan [EMAIL PROTECTED] wrote: On Jan 21, Saadat Saeed said: opendir(DIR,$line\\c\$\\Docume~12) or errornos($line,1,NEW

Re: Re: Re: Sub not working as it should

I am sorry I am migrating over to perl (love the built in debugger) --- Saadat Saeed [EMAIL PROTECTED] wrote: Thanks for the quick reponse - looks like I confuse my vbscript skills a bit... I am new to perl and am migrating over to vbscript! Regards --- Jeff 'japhy' Pinyan [EMAIL

Reading writing to INI files

Hello, Are there any modules available that can read/write to INI files. Thanks in advance Saadat Saeed __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- To unsubscribe, e-mail: [EMAIL PROTECTED

RE: the File::Copy module

Hello, Thanks for all your inputs now below you mentioned copy(qq(\\machine1\share\$file),qq(\\mahine2\share\$file)) sorry for my ignorance but what is qq also if I want to be smart and copy it to the c: drive of some user - assuming I am running the script from a Domain Admin login eg.

the File::Copy module

I was just reading the File::Copy module. Now on a pure Win32 environment will this work copy(\\machine1\share\file1,\\machine2\share\file2); Or should I do something else??? __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software

Win32 registry

Hello, I am new to scripting (in general) and am an administrator of win32 based systems. I am deciding between Perl a number of other scripting technologies to standardise upon. The only thing that'll convince me for now is the abiltity to read and modify registries of machines connected over