Example of using use File::Remote to copy files from one Windows machine to another

2008-03-31 Thread Glen Plantz
drive of the remote machine. Thanks so much for any help. Glen Plantz Mitchell International ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Copying an Excel chart to PowerPoint

2007-07-17 Thread Glen Plantz
Hi Folks, I need to copy an Excel Chart to PowerPoint. I've found VBA code to do this, but I'm having trouble converting it to Perl. Could some kind soul please lend me a hand? I would be eternally grateful. Thanks in advance for any help. Glen Plantz Mitchell International Here is the VBA

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

2007-02-01 Thread Glen Plantz
. I've done things similar to this many times. Can anyone see any problems with the above code??? Thanks in advance for any help. Glen Plantz Mitchell International San Diego, California ___ Perl-Win32-Users mailing list Perl-Win32-Users

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
in advance for any tips. Glen Plantz ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

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

2006-05-01 Thread Glen Plantz
. Glen Plantz ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

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

2006-03-29 Thread Glen Plantz
an EXISTING hyperlink 'Address' property? Thanks in advance for any help. Glen Plantz ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

using unlink on Win32 results in permission denied error

2006-02-09 Thread Glen Plantz
files that remote processes h . . . Could some kind soul please tell me how to deal with this problem? I'm sure this must be an FAQ, but I can't see a solution using Google. Thanks in advance for any help. Glen Plantz ___ Perl-Win32-Users

creating ZIP file that is password protected

2006-01-25 Thread Glen Plantz
the Archive::Zip documents, but I don't see any method to programmatically add a password to the ZIP file that is created. Thanks in advance for any help. Glen Plantz ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe

Copy vs Add when adding sheets to a workbook past 255

2006-01-22 Thread Glen Plantz
for all the other sheets in this workbook that I'm creating. Thanks in advance for any help here I'm stumped. Glen Plantz Here is my original post... # **

converting from Row, Column to Cell Name, and back, in Excel

2006-01-04 Thread Glen Plantz
Title: Message Hi Folks, Could someone tell me how to convert from the "Row, Column" ( 1,1) reference to a Cell to using the "Cell Name" ( A1) ? I know this is an FAQ, but I can't seem to find an answer. Thanks for the

Formatting a Date in a Cell in Excel

2005-12-15 Thread Glen Plantz
Any help will be greatly appreciated Thanks, Glen Plantz Here is my code;. --- my ($currentMonth, $currentYear ) = split / /, $currentMonthYear; #

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

2005-12-06 Thread Glen Plantz
. Thanks in advance for any help. Glen Plantz Mitchell International [EMAIL PROTECTED] Here is my code: my $excel_app = Win32::OLE-new('Excel.Application')or die "could not create excel app\n"; $excel_app-{'Visible'} = 1; $excel_app-{ 'SheetsInNewWorkbook'