RE: problem during accessing excel using OLE.

2004-11-03 Thread Chandrasekaran Suresh
Hi All, Someone can tell me how to read a excel file when perl is running on Unix. Regards, Suresh C. --- [EMAIL PROTECTED] wrote: > Thanks Brian, > > I've sorted it out. > The property DisplayAlerts stops all the prompts and > messages from the > excel. > So I just used > $excel -> {Displ

Re: Question about $emailto

2004-11-03 Thread $Bill Luebkert
Amanda Sherwin wrote: > I'm using a script that adds names to a database and sends a copy of their > information both to the user and to myself. This is the script: > > #Provide e-mail to send notices to. The backslash before the @ > #is required! > $emailto="$Email"; > $emailto="[EMAIL PROTECT

Re: Question about $emailto

2004-11-03 Thread Brant Evans
You are over writhing the $emailto variable. The second $emailto assignment should be $emailto .= " [EMAIL PROTECTED]" You may also need a semicolon, or comma to separate the email addresses depending on you mail program. To simplify the assignment I would acutally use the syntax: $emailto = $E

Question about $emailto

2004-11-03 Thread Amanda Sherwin
I'm using a script that adds names to a database and sends a copy of their information both to the user and to myself. This is the script: #Provide e-mail to send notices to. The backslash before the @ #is required! $emailto="$Email"; $emailto="[EMAIL PROTECTED]"; #Provide e-mail to send notice

RE: Incomplete combinatorics

2004-11-03 Thread Ying Yang
Morning, Thanks for all the help you offered for my question. Regards, Ying ___ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

RE: problem during accessing excel using OLE.

2004-11-03 Thread sharma.tarun
Thanks Brian, I've sorted it out. The property DisplayAlerts stops all the prompts and messages from the excel. So I just used $excel -> {DisplayAlerts} = 'False'; and then $Book->Close; It worked. My problem is sorted out. I also include your idea of not quitting excel application. Now all my b

RE: problem during accessing excel using OLE.

2004-11-03 Thread Brian Raven
[EMAIL PROTECTED] wrote: > Brian, > > When I call close on workbook rather than excel it prompts the message > to save the file. Which need human intervention. That I don't want as > I'm trying to automate the process. Can you tell me any property of > workbook or some way to just close the file w

RE: problem during accessing excel using OLE.

2004-11-03 Thread sharma.tarun
Brian, When I call close on workbook rather than excel it prompts the message to save the file. Which need human intervention. That I don't want as I'm trying to automate the process. Can you tell me any property of workbook or some way to just close the file without getting the prompt. Excel appl

RE: problem during accessing excel using OLE.

2004-11-03 Thread Brian Raven
[EMAIL PROTECTED] wrote: > > You're right Donald. > I open a file, run macro, save it as csv, quit excel, and then open > it again to process the new file. > So, how can I handle this situation. I would have thought it better to call close on the workbook object rather than quit on the applicati

RE: problem during accessing excel using OLE.

2004-11-03 Thread sharma.tarun
You’re right Donald. I open a file, run macro, save it as csv, quit excel, and then open it again to process the new file. So, how can I handle this situation.   Regards Tarun   -Original Message- From: Stephens, Donald [mailto:[EMAIL PROTECTED] Sent: 02 November 2004 18:45